"Michel Cadot" <micadot{at}altern{dot}org> wrote in message
news:40bc3f76$0$12086$626a14ce@news.free.fr...

> It works for me:
>
> SQL> select
unistr('\0067')||unistr('\0072')||unistr('\00F6')| |unistr('\00DF')
> 2 from dual;
>
> UNIS
> ----
> größ
>
> 1 row selected.
>
> It's an Oracle 9.2.0.4 on French WinNT4 SP6 (code page 1252).
> DB charset is WE8MSWIN1252 and ncharset UTF8.
>
> Ifaik, Windows uses UCS2 and not UTF8.


Right.... that's nice for you. But it doesn't exactly help me a great deal,
does it?

I have tried it with precisely that combination of character sets, and no
joy. So do I have to apply for a French passport for it to work, or what?

I am unaware of anything to do with settings for code pages in Win2KAS, but
I'm sure there must be. Somewhere. But that doesn't explain Linux not
playing ball either. But leave that out of it for the moment. Do I have to
do something to Windows to make it display properly, or what? Do you, or
indeed anyone else, have anything perhaps a tad more concrete by way of
suggestions for a fix?

But thank you for taking the time to check my original syntax was fine. And
also proving that I wasn't completely loopy using Character Map to determine
the Unicode values. That was very valuable indeed.

Regards
HJR