Nino Katic wrote: > Hi, > > Is there somewhere some good soul that could help me solve > the following > nightmare? I'm trying one simple and ordinary thing and that's to have > internatioanal characters in DB which can be sorted corectly > by the same DB. > I'm new to SAP DB because of that (i was using MySQL when i > realized that > it's hard to implement it there). I'm using Unicode DB and > now i only want > to have it sort country specific characters properly. I'm > using php as a > client, and win as an OS. So, can someone tell me how to do > it? One more > (friends) question: is it possible to use index on mapchar to > speed things > up? Thank you.
1. as written several times: for sorting international characters according to some country-specific sequence needs the function MAPCHAR. And as written on 25.Feb. 2003: starting with kernel-version 7.4.3.14 (no timeschedule so far) it will be possible to create and use mapchar sets even in a unicode-database. CREATE MAPCHAR SET <mapchar set name> AS ASCII | EBCDIC | UNICODE WITH <byte_string> TO <byte_string> | <string_literal> In case a MAPCHAR SET is defined AS UNICODE the first <byte_string> has to describe 2 bytes (4 <hex_digits>), the second <byte_string> resp. <string_literal> has to describe 2 bytes or 4 bytes (4 or 8 <hex_digits> resp. 1 or 2 character). A MAPCHAR SET defined AS UNICODE can be used only for values of datatype UNICODE, other MAPCHAR SETs cannot be used for values of datatype UNICODE. 2. as written (and being found by myself in the archive) by Thomas on 19.Feb. 2003 As already announced in my mail from 12 Feb 2003, user defined functions together with function based indexes are planned for release 7.4.4. It will not be possible to use an index directly on a predefined function. Only user-defined functions will have this possiblility. But defining a user-defined-function on top of a predefined will be very easy. And before the next question occurs: It will available in 7.4.4 and there is no timeschedule so far for this release. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
