Page 1 of 1

Unicode in OraDirect.Net 3.50.09

Posted: Thu 11 May 2006 14:39
by maurerp
Hi,

i've done some testing with OraDirect.net components and have problems with east asian languages (charactersets).

I use oracle 10g database server and Visual Studio 2005. Wanted to post unicode data into a db table. (see below)

ファッションコーディネート

Unicode attribute in the connection object is set to true. After posting data and query it in a db tool, i can't see the east asian characters (only special characters). I have the problem both in direct mode and oci mode.

When i do exact the save test with the componentes in system.data.oracleclient, everything works fine.

Any ideas?
Regards
Patrick

Posted: Thu 11 May 2006 15:09
by Paul
What is database charset (SELECT Value FROM nls_database_parameters where PARAMETER='NLS_CHARACTERSET')? What is localization in Windows regional settings? Do you have a problem after INSERT or SELECT operation? Can you see inserted text in database using db tool?
Send us please small demo project to demonstrate the problem and include script to create server objects.

Posted: Fri 12 May 2006 12:35
by maurerp
NLS_CHARACTERSET is "WE8MSWIN1252"
NLS_NCHAR_CHARACTERSET is "AL16UTF16"

Oracle 10g

Regional setting is german. Files for east asian languages are installed.

I've sent you a sample project to [email protected].

We've both problems after insert and select. After posting data (japanese characters) into db we only see special characters using db tool. If we post japanese characters in db over db tool and select via OraDirect.NET, we also see special characters.

Same sample with the built in components in system.data.oraclient works fine.

Regards
Patrick

Posted: Tue 23 May 2006 07:33
by Alexey
Please send us script to create server objects.