[EMAIL PROTECTED] wrote: > > 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. >
1. AFAIK ORDER BY would work on UPPER(original column), too, so that no extra column(with trigger to fill/update) is needed. 2. As all sorting is done, it is done bit-wise, even with DBCS. As UPPER will work even on those languages/part of them where it is possible for us (see mail of yesterday), even for DBCS ORDER BY with UPPER(original column) should do. Elke SAP Labs Berlin > 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]
