PDA

View Full Version : String literals containing ?



barrymavin
2013-02-16, 22:04
There is a known isssue in the windows ODBC libraries that causes them to get confused when you specify ? in a string literal in a SQL command.
http://stackoverflow.com/questions/3348932/how-to-avoid-odbc-parameterization-for-the-question-mark-character-within-lite

To get around this, do this:

insert into mytable(name) values("hello" + chr(63) + "world")

instead of:

insert into mytable(name) values("hello?world")

barrymavin
2013-02-17, 06:36
I have worked around this issue and it is now fixed in RC4.