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
Unicode in OraDirect.Net 3.50.09
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.
Send us please small demo project to demonstrate the problem and include script to create server objects.
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
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