06-13-2006 06:42 PM
06-13-2006 06:58 PM
06-14-2006 11:24 AM
If two single quotes don't work, try backslash single quote, like \'
The backslash is often used as an escape character, meaning to treat the next character literally.
06-14-2006 11:28 AM
Russ,
It works! Thanks for the info
Waldo
03-05-2022 05:43 AM
I have the same problem with an with a string with "é".
After insert "e" become "?".
Could you help me.
03-06-2022 07:21 AM - edited 03-06-2022 07:22 AM
That’s an encoding problem and totally different from the original problem. LabVIEW uses ANSI strings which use whatever codepage your system is configured with. Depending on your database driver he may convert such strings to Unicode on your computer in which case there is no problem. But many just send the binary codes for the ASCII characters and then the database has to guess what codepage they were in which is of course s hopeless exercise and it just uses whatever codepage its own computer is set. For some databases or specific tables you can set the codepage to use and sometimes a database driver allows explicit configuration but each database uses it’s own options here, and sometimes even different drivers for the same database backend are inconsistent.