sqlite issue using WHERE statement on a varchar field in Objective-C
Posted
by Geykel
on Stack Overflow
See other posts from Stack Overflow
or by Geykel
Published on 2010-03-24T16:10:11Z
Indexed on
2010/03/24
16:13 UTC
Read the original article
Hit count: 263
Hi,
I have this sql statement SELECT * FROM Language WHERE LanguageCode=? where LanguageCode is a varchar(2).
When I use sqlite3-prepare-v2 on that statement I got SQLITE_ERROR but if I use SELECT * FROM Language WHERE LanguageID=? where LanguageID is the primary key numeric identity field the statement compiles just fine.
Is there any issue filtering by a varchar field using WHERE statement?
Thanks
© Stack Overflow or respective owner
