Hi!

We are using PVSW2000i native and via SQL/ODBC. Is there an option for
collating sequences? German umlauts in the actual situation are behind
"Z".

Example:

SELECT Ort FROM Kunde ORDER BY Ort

Result:

Winterthur
Zürich
Örlikon
Östringen

Winterthur and Zürich should be behind Östringen.


Are there any solutions?

cu
Andreas

You probably should be using International Sort Rules. Look this up in the
on-line manual -- or look for ISR instead -- for more information.
BB

Andreas Niggemann wrote: