Advertisement

09.28.2008 at 12:16AM PDT, ID: 23769305 | Points: 500
[x]
Attachment Details

Choosing a Character Set

Asked by Suriyaraj_Sudalaiappan in Oracle 9.x, Oracle 10.x

Tags: , ,

Hi,
      I have 2 machines. A server which has UNIX, Oracle 10g v2. And a client machine that has Windows XP Professional, oracle 9i client. I don't have access to server machine. I can access only client machine.

People has created a database on the server machine and used the character set UTF8. And my Windows client character set is WE8MSWIN1252.

I ran a script throught the SQL Worksheet to create a table and store unicode characters in it. I ran this script on server. When I look at the data in this table through any oracle tool on the Server I see the same unicdoe characters come up no problem. If I run the same program on the client machine the unicode characters comes up all scrambled english characters like some replacement character(¿). I have to see the the same unicode value in my client machine. It means my windows client has to support that unicode character.

Does anyone know  what I have to do?

Thank you
Suriya
Start Free Trial
[+][-]09.28.2008 at 12:42AM PDT, ID: 22590184

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.28.2008 at 03:14PM PDT, ID: 22592767

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-42 / EE_QW_2_20070628