Hi,
with the next version of SAP DB (7.3.0.28) the SQL-function
CASE as known from some other database systems is available:
as
<simple_case_function> ::=
CASE <check_expression>,
WHEN <search_expression> THEN <result_expression>
[...]
[ELSE <default_expression>])
END
<check_expression> | <search_expression> | <result_expression> | <default_expression>
::= <expression>
and as
<searched_case_function> ::=
CASE
WHEN <search_condition> THEN <result_expression>
[...]
[ELSE <default_expression>])
END
<result_expression> ::= <expression>
<default_expression> ::= <expression>
====================
With the same new version (no time schedule available) the
SQL-functions UPPER and LOWER should work correctly even for
Unicode-columns in this way:
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.
Hope, this will help
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
