Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hi Frank,
>yes, the default can be changed, but what will the default be on a Korean Windows/VFP combination? Will it be Korean or Machine (assuming no one has changed the config file).
>
>Just to recap, the problem is that apparently on an INDEX ON statement against a DBF with code page=1252, on a Windows/VFP Korean system, we get the "Collating Sequence 'KOREAN" is not found" error.
>
>Our application has not changed COLLATE setting, nor code page.
>
I don't have a machine with Korean Windows handy to verify, but, after looking through the source code, I believe it is very likely that VFP will use Korean collate by default. To be more specific, VFP will use Korean collate by default if GetSystemDefaultLCID() Win32 API function returns 0x0412.
>Could this error occur if Korean characters were entered into the dbf?
>
No, simply entering Korean characters will not change current collate.
>Should we let the users decide what code page and what COLLATE setting they want to use and have our application adjust accordingly?
>
That depends on the purpose of your application.
Aleksey.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement