At 10:24 AM 11/08/2004 +0000, you wrote:

>Dear Helen,
>Thank you!
>I had success in a column-level:
>CREATE TABLE TEST (
> ID INTEGER NOT NULL,
> DESCR VARCHAR(50) COLLATE PXW_GREEK
>);
>
>"select upper(descr) from test" (without SQL-level COLLATE) worked ok!
>
>Now what remains is to resolve the following issues:
>(1) How can I upper a string literal? eg select upper('my greeks
>here') from rdb$database

select upper (_win1253 'my greeks here') collate pxw_greek
as ucasegreek from rdb$database

>(2) In General, WIN1253 is a "restricted" Windows Encoding. The
>perfect for us is to find out how to work with Unicode wich is (a) a
>standard and (b) truly multilingual: Our projects have most EU
>languages (Greek, Spanish, German, French etc) so ISO-8859-7 and
>WIN1253 are Greek-Only (+English)!
>
>So, Could you pls help me with Unicode? I will greatly appreciate
>this!

As I indicated before, UNICODE_FSS is not a happy story if you want
lower-upper case mappings. UNICODE_FSS has one and only one COLLATE
sequence, and it's binary.

But - don't give up hope. Peter Jacobi will spot your message and have
something more useful to offer on the subject. :-)

Please would you trim your messages...

^heLen