Hi,

i wanted to do

   "select * from ansprache order by myvarcharfield COLLATE ANSI"

for a table where i have the values

Aaaa
Bbbb
Oooo
Öööö
Rrrr

in normal UNICODE mode the Öööö will be the last row if i order by this
field. To show the Öööö right after Oooo i need to order by text-field
with collate ansi but now i get this error:

ElevateDB Error #700 An error was found in the statement at line 1 and
column 49 (ElevateDB Error #401 The collation ANSI does not exist in
the configuration xxxx)

Our database is running Characterset: Unicode


--
--
Yusuf Zorlu | MicrotronX

Yusuf Zorlu wrote:

>    "select * from ansprache order by myvarcharfield COLLATE ANSI"

Arrgh ... not ANSI, if i use DEU it works but is this available on all
systems? Can i change my queries within the app to use "order by
mycompanyname COLLATE DEU" and it works on all systems?

--
--
Yusuf Zorlu | MicrotronX

Yusuf,

The collation ANSI doesn't exist if you use Unicode, as UNI doesn't exist if you are using the ANSI charset.
In all other cases the collation codes are the same.

--
Fernando Dias
[Team Elevate]