Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Sql problem in different language OS
In the past,
I am using Window English Version or Traditional Chinese Version.
The following sql is :-
SELECT * from companytable where companytable.code >= pStartCode .AND. code <= pEndCode
case 1)
if the pStartCode and pEndCode are the same. e.g(IBM)
the sql will list out the information equivalent to "IBM" only
the sql work fines on all OS
case 2)
if the pStartCode = "A", pEndCode = "C",
the sql will list the information which starting form "A" to "B"
this works fine on all OS
However,
case 3)
if the pStartCode ="A" and pEndCode = "["
the sql will list the information which starting from "A" to "Z"
it only work on Window English Version or Traditional Chinese Version.
BUT, it didn't work on Simplified Chinese Window Version.
I can't use the syntax of ' left(code,1) <="A" ', since the user may input fullname
to "pStartCode" and "pEndCode"
SO. pls Help..
Thanks
From Agnes
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