[SQL] Difference between " and '

[Ruslan Zasukhin]

on 12/24/03 5:54 PM, Eric Forget at forgete at cafederic.com wrote:

>>> I found something in an SQL query:
>>> 
>>>   SELECT RecID FROM Table WHERE Country = 'FR-M'
>>> 
>>> and
>>> 
>>>   SELECT RecID FROM Table WHERE Country = "FR-M"
>>> 
>>> do not behave the same. The first one will accept countries equal to "FR"
>>> but not the second. Is it a normal SQL behavior?
>> 
>> No.
>> 
>> By SQL standard ONLY single quotes should be used for string constants.
> 
> So, it is weird that I could make it work only with double quote, no? And
> not for all!

Agree. This is why ask about index by words.

REINDEX not help?


>> Does your Country field have flag Index by words?
> 
> The only flag it has is indexed. The length is 2, in case it may impact:

Length of what is 2 ?

    String[2] ?


> the length of the string to compare with is from 2 to 6...

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------