-----Oryginalna wiadomość-----
Od:     Elias Martenson [SMTP:[EMAIL PROTECTED]]
Wysłano:        6 lutego 2003 20:49
Do:     [EMAIL PROTECTED]
Temat:  Re: mapchar sets & UNICODE problem

Den Thu, 06 Feb 2003 15:27:51 +0100 skrev Łukasz Borzęcki:

>
> How should I transfer my mapchar set to another database?
>
> The above example is for ASCII database, but what should I do to achieve
> proper sorting of polish characters in UNICODE database?
>
> Regards
> Łukasz Borzęcki

I'm pretty sure you can't use mapchar sets in UNICODE, mainly because you
don't need them. I don't think the reason you have mapchar sets in ASCII
is for sort orders, but rather to be able to store certain characters
alltogether. Using UNICODE you can already store all characters.


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

I know that i can't use mapchar sets in UNICODE. Maybe the question was 
unfortunately formed but:

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

Reply via email to