Re: PVSW2000i SQL ODBC Collating Sequence

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:

> 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