saving data with apostrophes

databases United States
  • 19 years ago

    How do I go about saving data that contains apostrophes from VB to MS SQL Server?

  • 19 years ago

    try doing this...


    "mys tring goes in here with a sigle quote' like this "


    if you use double


    "my double quote "" looks like this"


    if it doesnt work try the double  ' ' two in a row that is...


    may work I dont know why you have a problem encapsulating single quotes in doubles.. theyr not the same

  • 19 years ago

    Thanks!

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“C++ : Where friends have access to your private members.” - Gavin Russell Baker