OraDirect.NET can not use Big-5 character set

OraDirect.NET can not use Big-5 character set

Postby Liao Thung Sheng » Fri 05 Nov 2004 02:07

Command1.CommandText =
" select * from Customer where custname = '³¯§Ó©ú' "

always get error, but

Command1.CommandText =
" select * from Customer where custname = 'ABC' "

this sql it's ok.

:x
Liao Thung Sheng
 

Re: OraDirect.NET can not use Big-5 character set

Postby Oleg » Fri 05 Nov 2004 15:32

You can settle this problem by setting OracleConnection.Unicode property.
This option works if you have installed Oracle Client version 9.2. or higher.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: OraDirect.NET can not use Big-5 character set

Postby Guest » Tue 07 Dec 2004 05:19

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.
Guest
 


Return to dotConnect for Oracle