Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with XMLType attribibutes? please confirm

Re: Problem with XMLType attribibutes? please confirm

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 03 Aug 2005 20:54:03 +0200
Message-ID: <dcr3fs$i86$1@news4.zwoll1.ov.home.nl>


Maxim Demenko wrote:
> Frank, both, sqlplus and sqlplusw don't differ regarding the UTF8. Both
> are not 'UTF enabled', iSqlplus , for example, does. The codepage is
> responsible for the characters can be displayed on your terminal, and ,
> in 1252 'ü' can be definitely displayed.
> The difference you experienced is most probably only due to differences
> in NLS_LANG setting for both clients ( sqlplus and sqlplusw ). I'm not
> so familiar with windows, so i can not explain , why is it, but if you
> try to drop the my_table and do the whole exercise in sqlplus.exe ( also
> command-line) , you should see the correct results ( but weird
> characters in sqlplusw ). The whole issue is only about NLS_LANG
> ,database charset and character conversion, not about UTF8 and
> codepages... ( i meant of course only mangled 'ü' part from OP , indeed
> there are more problems as it seems ).

Nope - same results on sqlplus for the full monty (apart from a mangled u umlaut)

-- 
Regards,
Frank van Bortel
Received on Wed Aug 03 2005 - 13:54:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US