" select * from Customer where custname = '³¯§Ó©ú' "
always get error, but
Command1.CommandText =
" select * from Customer where custname = 'ABC' "
this sql it's ok.
OraDirect.NET can not use Big-5 character set
-
Liao Thung Sheng
OraDirect.NET can not use Big-5 character set
Command1.CommandText =
" select * from Customer where custname = '³¯§Ó©ú' "
always get error, but
Command1.CommandText =
" select * from Customer where custname = 'ABC' "
this sql it's ok.
" 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
You can settle this problem by setting OracleConnection.Unicode property.
This option works if you have installed Oracle Client version 9.2. or higher.
This option works if you have installed Oracle Client version 9.2. or higher.
-
Guest
Re: OraDirect.NET can not use Big-5 character set
Our Oracle Server is 8.1.7.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.
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.