=?ISO-8859-2?Q?=A3ukasz_Borzęcki?= wrote:
I know that i can't use mapchar sets in UNICODE. Maybe the question was unfortunately formed but:The point is that you can't. You have to sort externally. The ordering in UNICODE follows UNICODE character id's which happens to place all national characters after a-z. That's the way it is, and I agree that it would be nice to have it another way. We use non-english characters too so I suffer with you.
I HAVE TO use mapchar sets in ASCII database for proper sorting of national characters (ORDER BY mapchar(<column_name>) clause), RTFM.
Both types of databases ASCII and UNICODE store national characters properly (German characters for example).
But in case of polish characters: all of them are placed after every other character so:
should be:
a...<polish_char>...z
is
a...z...<polish_char>
With mapchar sets i can solve the problem in ASCII database, but i don't know how to do this in UNICODE database.
I need transfer the mapchar set from one ASCII database to another because i don't want edit this manually every time i start new database instance.
Regards
Łukasz Borzęcki
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
