Re: MapChar and UpperCase

[Jurand]

Zabach, Elke wrote:

Jurand wrote:

Zabach, Elke wrote:

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

OK i'll try but it seems to be usable only for comparision only but not for direct character translation like (use 8859-2)
? -> ? 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

Installing Unicode database means to set _UNICODE to YES during the
first installation of the database. It is NOT !!! possible to change it afterwards.
It is not possible because every info about users, tables, views and so
on is stored according to this parameter. And just changing the installtion
parameter would not help.

--> start with a fresh database with _unicode set to YES,
insert (with the help of the replication manager) your data into this new database.
And then your upper/lower should work as expected.

Elke
SAP Labs Berlin

It's seems not work (maybe it is problem of my wierd :-) computer )-i'll chck it at home
I've created simple table T1
with int and char(40) fields (F0 and F1)
filled like this :

1. BRZDąC
2. Książka

(databese _unicode = YES and columns are stored as _unicode)

Select Upper(F1) from t1
results:
--------
BRZDąC
KSIążKA

Or .. maybe I need create mapchar sets (i understood that this is not function for Unicode - only for ASCII and EBCDIC ) ???

Thx for reply

Tomasz Jureczko





_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general