Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC and Unicode
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
![]() |
![]() |