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

Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC and Unicode

Re: ODBC and Unicode

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 10 Jan 2007 04:49:49 -0800
Message-ID: <1168433388.961442.202540@k58g2000hse.googlegroups.com>


Alain Migeon wrote:
> In article <MPG.200d775ab7521379896d6_at_news.free.fr>,
> migeon.alain_at_tdcspace.dk says...
> >
> ...
>
> By the way, I tried to copy / paste some Unicode characters in SQL*Plus,
> and there were all replaced by ?. That let me think that it is not
> allowed at that time to place directly any Unicode characters in a SQL
> query.
>

Unicode characters work without any problem whatsoever in SQLplus as long as the client character set is set correctly and the characters you're putting in there are supported by your shell. You can try this by not using c&p but using a UTF8 text file with the statements and running this in sqlplus - it should work w/o problem. (Except if the text file has a Byte Order Mark at the beginning in which case sqlplus will report an error for the first line.)

cheers,
Martin Received on Wed Jan 10 2007 - 06:49:49 CST

Original text of this message

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