p.cole
2nd December 2003, 11:29
What locales are people using in the user data locale setting (ttaad200.loca) when running with SQL Server? We would like to use ISO-8859-1, since this gives the following sort order.
KO
KÖ
KP
KZ
LA
Locale ISO_BIN gives the following sort order (that we don't want):
KO
KP
KZ
KÖ
LA
ISO_BIN also causes all our "To" form fields to default to "ÿÿÿÿÿÿ", instead of "zzzzzz".
Using ISO_BIN, stops error 305's that we were getting on indexes containing string fields with extended characters (e.g. Ö on tipcs020 index 2), but gives the wrong sort order.
Any ideas how to fix this? Anyone else experience the problem?
KO
KÖ
KP
KZ
LA
Locale ISO_BIN gives the following sort order (that we don't want):
KO
KP
KZ
KÖ
LA
ISO_BIN also causes all our "To" form fields to default to "ÿÿÿÿÿÿ", instead of "zzzzzz".
Using ISO_BIN, stops error 305's that we were getting on indexes containing string fields with extended characters (e.g. Ö on tipcs020 index 2), but gives the wrong sort order.
Any ideas how to fix this? Anyone else experience the problem?