Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL SELECT and code pages problem
Message
From
29/07/2001 16:40:48
 
 
To
27/07/2001 03:21:51
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00535512
Message ID:
00537027
Views:
19
>>Thanks, Cetin.
>>
>>Please, can you be more specific concerning the Title of the discussion
>>about SQL strings comparison problems.
>
>Pavel,
>Check Thread #483532
>It doesn't have collating at all and trimming is an issue. However 'set ansi on' vs '==' was a solution. This makes me think if field lengths are different w/o set ansi any string comparison might fail.

Cetin,

thank you for the pointer to the previous discussion, but I think
its subject is not very suitable for my needs. My problem is based
on code pages differences between DOS and Windows FoxPro tables,
not on exact string comparison (SET ANSI etc.).
But, I've found some sort of solution of my problem - see Message
#537026.
Thank you for your help.

Pavel Kouril
Pavel Kouril
Previous
Reply
Map
View

Click here to load this message in the networking platform