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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
