Jan Hlavatý wrote: > > Zabach, Elke wrote: > > --> if UPPER/LOWER is needed for a non-western-european > language, the installation parameter > > _UNICODE hast to be set to YES (Unicode-database) AND > the corresponding column(s) > > has/have to use UNICODE-storage and the newset kernel > has to be used. > > Well, that doesn't help for me (7.4 beta on RedHat Linux 8.0). > With 7.3 on Windows 2000 it worked (probably using Windows > API to do it) >
I am not astonished. It is implemented with 7.4.3.10. And the so-called 7.4beta is 7.4.3.7 --> does not include the correct upper/lower-conversion for unicode-data. > What I need is to be able to convert these (hope they go through, I'm > using UTF-8 in this message): > > lower: á č ď é ě í ĺ ľ ň ó ř š ť ú ů ý ž > upper: Á Č Ď É Ě Í Ĺ Ľ Ň Ó Ř Š Ť Ú Ů Ý Ž > > I can provide some tables if you need. > > Also, I need some way to create collation orders - I was hoping to > create some user defined function that would return binary-orderable > byte sequence from source strings, but I found no way to do that. > Cound you extend sapdb to allow for that? > > Something like USER_COLLATE(collation name, string) that > would use some > user definable table to convert Unicode characters (and > combinations of > characters) to their ordinal numbers in given collation sequence, > possibly encoded in variable length binary collatable encoding like > UTF-8 to keep it small but still binary comparable. In Czech > collation > sequence, character pair CH has to be ordered between H and I for > example, so there may be more ordinal numbers than > characters, hence the > variable length encoding. > > With this function, we could either use it as derived column > or place it > in a trigger to fill in a collation field, enabling indexes in given > collation order that even query optimizer can use... There are no plans to have collations. And there are some ideas, but no real plans/time schedule or so for user-defined functions. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
