Page 1 of 1
OraDirect.NET can not use Big-5 character set
Posted: Fri 05 Nov 2004 02:07
by Liao Thung Sheng
Command1.CommandText =
" select * from Customer where custname = '³¯§Ó©ú' "
always get error, but
Command1.CommandText =
" select * from Customer where custname = 'ABC' "
this sql it's ok.
Re: OraDirect.NET can not use Big-5 character set
Posted: Fri 05 Nov 2004 15:32
by Oleg
You can settle this problem by setting OracleConnection.Unicode property.
This option works if you have installed Oracle Client version 9.2. or higher.
Re: OraDirect.NET can not use Big-5 character set
Posted: Tue 07 Dec 2004 05:19
by Guest
Oleg wrote:You can settle this problem by setting OracleConnection.Unicode property.
This option works if you have installed Oracle Client version 9.2. or higher.
Our Oracle Server is 8.1.7.
I'm tested with VS.NET 2003 built in Oracle.NET data Provider, has no problem, only your OraDirect.NET can't not use Big-5 character set.