Hi Elke, All, Ok...do you have any suggestion on how I can handle sorting with DBCS? At the moment, as SAP has case-sensitive sorting (upper letters always come before lower counterparts) we use an extra column which is in UPPER case and sort on that.
Cheers, David "Zabach, Elke" <[EMAIL PROTECTED]> on 08/10/2003 02:36:00 AM To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] cc: Subject: RE: UPPER with DBCS [EMAIL PROTECTED] wrote: > > Hi, > > How does SAP handle the UPPER function with DBCS? Isn't > uppercase pretty > language-specific in double-byte character sets? > You are right, it is language-specific. It is handled as J�rg wrote last year: lower/uppercase mapping for unicode is implemented using tables extracted from unicode.org ftp side. (see vsp81.c created by genUCS2CaseMaps.pl). There is a compromise however, between a database and a text editor for some characters (like German-Sharp-S, ligatures, some precomposed characters and all letters with 'iota-subscript' or 'iota-adjust'. In short words: all convertions, that would modifiy the length of the string are not handled correctly and could not, since the internal interface does not support different input and output length before and after conversion. Only those SINGLE UCS2 characters which have a well-defined SINGLE UCS2 uppercase counterpart are therefore handled as expected. Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
