Question on character set in Oracle

zvasku · Post by **zvasku** » Sun 18 Sep 2011 20:19

Hello,

I have a question on character set detection or conversion in Oracle uni provider. Our application is developed in D2007 ansistring (non unicode) with UniDac 3.7. 100% of our working evironment is WIN1250 ansi encoding. Oracle national setting is EE8MSWIN1250. All our computers/servers are ok(W2003, W2008, W2008R2, XP,Vista,7), but we have one (and only) server with W2008SP2 where some national characters (ěščřž...) are recoded/damaged during insert or update in oracle.
Is there any detection code for national charsets in OracleUniProvider or is it a OCI problem?

Do you have any idea on this issue?

Thanks a lot
Zdenek

PS: Oracle 10g client

AlexP · Post by **AlexP** » Mon 19 Sep 2011 13:15

Hello,

Please send us the results of the execution of the following queries and specify the regional settings of the PC that inserts data correctly and of the one that inserts data incorrectly.

Code: Select all

SELECT USERENV ('language') from dual; 

SELECT * FROM V$NLS_PARAMETERS;

zvasku · Post by **zvasku** » Tue 20 Sep 2011 08:06

Hello,

you hit the point. Oracle returns AMERICA instead of our CZECH environment. So we try reinstal oracle client to solve this problem.

Thanks a lot
Zdenek

AlexP · Post by **AlexP** » Wed 21 Sep 2011 08:51

Hello,

Was the problem solved after reinstalling the client?

zvasku · Post by **zvasku** » Thu 22 Sep 2011 19:26

Hello,

last night we have reinstalled oracle client and all is ok now. Previous instalation failed on registry modification and all NLS parameter were not set.

Thanks for your assistance.
Zdenek

AlexP · Post by **AlexP** » Fri 23 Sep 2011 08:13

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.