Zabach, Elke wrote:
OK i'll try but it seems to be usable only for comparision only but not for direct character translation like (use 8859-2)Jurand wrote:Hi everybody
I have "critical" problem. The software I use uses Upper to convert lower chars to upper and Lower function to convert upper case to lower case. :-)) Yes it's easy. But what about national signs like german omlauts, french letters with accent, polish letters with "birds" .I've found function MapChar - ok this solves comparision problem but I need function that directly converts these signs (using eg Lower or Upper). Interbase, MSSQL and Oracle have this feature using codepages. Converting in application maybe is the way - but my very large app uses some components that are difficult to rewrite only for SAP DB.
May I write my function (eg UpperPL ) that converts these signs (any axamples please) ??????
Tomasz
Please use a UNICODE-database and then the following mail (sent by Jörg 3 months ago) is true for you: http://listserv.sap.com/pipermail/sapdb.general/2002-September/014066.html Elke SAP Labs Berlin
ą -> Ą or Ą -> ą
ó -> Ó or Ó -> ó
I need Upper and Lower works like this :
Upper('ąćńłóśę') = 'ĄĆŃŁÓŚĘ'
Lower('ĄĆŃŁÓŚĘ')= 'ąćńłóśę'
Until it is not done SAP DB seems to be unusable for my systems :-(
As far as I know SAP DB does not support DB functions ???
What mean Installing Unicode database ??
_Unicode = YES
.... ???? (what else)
During installation in DB Manager occurs many errors while changing these params (described in other threads on this group)
Tomasz Jureczko
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
