Thanks. Thats what I thought but wanted to be sure.
On Fri, 11 Nov 2005, Guillaume MAISON wrote:
Tenkawa a écrit :
Query 1 (correct behavior)
sqlite> select id,nick,last from nicks where nick = 'Nick';
sqlite>
Query 2 (incorrect?)
sqlite> select id,nick,last from nicks where nick = "Nick";
4|Her|99
5|Her|99
6|Her|99
7|Him|99
8|You|99
When dealing with STRING values, use only single quotes.
in your second case, it will consider Column(nick)=Column(Nick)
which are obviously the same :)
HTH,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com
