Ali Engin Eroglu wrote: > Hi, Elke > I dont know if it is Ok to reply directly to your adress.
If we ask to provide some additional info it is ok to send directly to one of the SAP Labs Berlin. But please do _not_ do it with new questions. > My question is; If I use the Unicode, > can I have a Turkish sorting. The documents have lack of > information about this topic. In Turkish the capital of "i" > is not "I". Can I solve this problem? As far as I know (I do not know the Turkish sorting in detail), the unicode-definition was done according to a correct ascending ordering of the characters of one language. With SAP DB sorting is done in a binary manner from left to right, no matter if ascii/unicode character or anything else is stored in the columns. --> I assume that sorting will be ok. By now the explicit conversion (functions UPPER/LOWER) does not UPPER/LOWER character except those which are part of 7-bit-ASCII (english a..z / A .. Z). Only the conversion for the statements/identifier uses the conversion as was described in this mail (send Sept. 12.) Hi, 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. CU jrg We will change the behaviour of UPPER/LOWER with one of the next versions. I do not know how to overcome this problem in the meantime. Sorry. Elke SAP Labs Berlin > > ----- Original Message ----- > From: "Zabach, Elke" <[EMAIL PROTECTED]> > Date: Mon, 7 Oct 2002 14:18:33 +0200 > To: "'Ali'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: RE: How to support Turkish character set? > > > > Ali wrote: > > > > > Hi, > > > Although I read documentation, I am not sure how to > support Turkish > > > character set in SAPDB. > > > Has any one any experience creating an extra Language > character set? > > > > The best alternative for those languages not being stored > with Latin1 is > > to use UNICODE. > > SAP DB always expects to have Latin1 (if not Unicode) and this will > > result in incorrect result sometimes if it is not Latin1. > > > > Elke > > SAP Labs Berlin > > > > -- > __________________________________________________________ > Sign-up for your own FREE Personalized E-mail at Mail.com > http://www.mail.com/?sr=signup > > "Free price comparison tool gives you the best prices and cash back!" > http://www.bestbuyfinder.com/download.htm > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
