# Got strange characters in results - TOAD 10.6 **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [March 14, 2011, 11:18am UTC](https://forums.toadworld.com/t/got-strange-characters-in-results-toad-10-6/10308 "2011-03-14T11:18:31Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![nma01](https://avatars.discourse-cdn.com/v4/letter/n/ecd19e/32.png) [@nma01](https://forums.toadworld.com/u/nma01)\ **Post date:** [March 14, 2011, 11:18am UTC](https://forums.toadworld.com/t/got-strange-characters-in-results-toad-10-6/10308/1 "2011-03-14T11:18:31Z")
We installed TOAD 10.6 and our platform is Windows 7 64-bit. When I did test run, I noticed some columns changed to strange characters. For instance, currency code should be USD, but it should something like 单D䜀U某๔\_. Please advise how to get ride of them. Thanks, NMA. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 8, 2011, 5:10am UTC](https://forums.toadworld.com/t/got-strange-characters-in-results-toad-10-6/10308/2 "2011-06-08T05:10:42Z")
Message from: peter\_812 Hi, I have the same problem like you. Do you have a solution? best regards, Peter Anzenberger * * * Historical Messages Author: peter\_812 Date: Wed Jun 08 03:10:42 PDT 2011 Hi, I have the same problem like you. Do you have a solution? best regards, Peter Anzenberger \_\_ Author: ning ma Date: Mon Mar 14 09:18:31 PDT 2011 We installed TOAD 10.6 and our platform is Windows 7 64-bit. When I did test run, I noticed some columns changed to strange characters. For instance, currency code should be USD, but it should something like 单D䜀U某๔\_. Please advise how to get ride of them. Thanks, NMA. \_\_ * * * ---
**Author:** ![peter\_812](https://avatars.discourse-cdn.com/v4/letter/p/b5ac83/32.png) [@peter\_812](https://forums.toadworld.com/u/peter_812)\ **Post date:** [June 8, 2011, 5:10am UTC](https://forums.toadworld.com/t/got-strange-characters-in-results-toad-10-6/10308/3 "2011-06-08T05:10:42Z")
Hi, I have the same problem like you. Do you have a solution? best regards, Peter Anzenberger ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [June 8, 2011, 5:19am UTC](https://forums.toadworld.com/t/got-strange-characters-in-results-toad-10-6/10308/4 "2011-06-08T05:19:02Z")
Peter, - what is the characterset (and nls caharacter set) for the database? - what is the characterset in use on the client (NLS\_LANG)? - are they compatible? - what font is in use in the editor/grid/etc where you are seeing the strange characters? Try using courier new. Toad 10 does Unicode, but some fonts installed on Windows can’t display Unicode characters. Also, you may be seeing characteset conversion between the database characterset (aka NLS\_LANG) and the one in use on your client. If you have %NLS\_LANG% defined that will be used, otherwise, the registry at HKLM/software/oracle/HOMEn where ‘n’ is a digit. Cheersm Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) ---
**Author:** ![Mark\_Lerch](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mark_lerch/32/33_2.png) [@Mark\_Lerch](https://forums.toadworld.com/u/Mark_Lerch)\ **Post date:** [June 8, 2011, 6:54am UTC](https://forums.toadworld.com/t/got-strange-characters-in-results-toad-10-6/10308/5 "2011-06-08T06:54:06Z")
The Toad Advisor (under the Help menu) will also tell you whether or not NLS\_LANG is set properly ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [June 15, 2011, 8:57am UTC](https://forums.toadworld.com/t/got-strange-characters-in-results-toad-10-6/10308/6 "2011-06-15T08:57:43Z")
Message from: peter\_812 I got it: on my machine are 2 oracle homes installed - 8.0.6 - 11g Toad made the 8.0.6 the default toad home and so I got the chinese characrters. When explicitly choosing 11g (and make this definitly to the toad home) it works. But without definitly choosing 11g as default toad changed the home to 8.0.6 the next time and I got zhe chinese characters. Peter * * * Historical Messages Author: peter\_812 Date: Wed Jun 15 06:57:43 PDT 2011 I got it: on my machine are 2 oracle homes installed - 8.0.6 - 11g Toad made the 8.0.6 the default toad home and so I got the chinese characrters. When explicitly choosing 11g (and make this definitly to the toad home) it works. But without definitly choosing 11g as default toad changed the home to 8.0.6 the next time and I got zhe chinese characters. Peter \_\_ Author: mark.lerch\_828 Date: Wed Jun 08 04:54:06 PDT 2011 The Toad Advisor (under the Help menu) will also tell you whether or not NLS\_LANG is set properly \_\_ Author: Norman Dunbar Date: Wed Jun 08 03:19:02 PDT 2011 Peter, \* what is the characterset (and nls caharacter set) for the database? \* what is the characterset in use on the client (NLS\_LANG)? \* are they compatible? - what font is in use in the editor/grid/etc where you are seeing the strange characters? Try using courier new. Toad 10 does Unicode, but some fonts installed on Windows can’t display Unicode characters. Also, you may be seeing characteset conversion between the database characterset (aka NLS\_LANG) and the one in use on your client. If you have %NLS\_LANG% defined that will be used, otherwise, the registry at HKLM/software/oracle/HOMEn where ‘n’ is a digit. Cheersm Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) \_\_ Author: peter\_812 Date: Wed Jun 08 03:10:42 PDT 2011 Hi, I have the same problem like you. Do you have a solution? best regards, Peter Anzenberger \_\_ Author: peter\_812 Date: Wed Jun 08 03:10:42 PDT 2011 Message from: peter\_812 Hi, I have the same problem like you. Do you have a solution? best regards, Peter Anzenberger \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Historical Messages Author: peter\_812 Date: Wed Jun 08 03:10:42 PDT 2011 Hi, I have the same problem like you. Do you have a solution? best regards, Peter Anzenberger \_\_ Author: ning ma Date: Mon Mar 14 09:18:31 PDT 2011 We installed TOAD 10.6 and our platform is Windows 7 64-bit. When I did test run, I noticed some columns changed to strange characters. For instance, currency code should be USD, but it should something like 单D䜀U某๔\_. Please advise how to get ride of them. Thanks, NMA. \_\_ \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ \_\_ Author: ning ma Date: Mon Mar 14 09:18:31 PDT 2011 We installed TOAD 10.6 and our platform is Windows 7 64-bit. When I did test run, I noticed some columns changed to strange characters. For instance, currency code should be USD, but it should something like 单D䜀U某๔\_. Please advise how to get ride of them. Thanks, NMA. \_\_ * * * ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [June 15, 2011, 8:57am UTC](https://forums.toadworld.com/t/got-strange-characters-in-results-toad-10-6/10308/7 "2011-06-15T08:57:43Z")
Hi Peter, > > Toad made the 8.0.6 the default toad home and so I got the > > chinese characrters. > > Yes, Oracle 8.0.6 client didn't do Unicode as far as I remember. So your > > database Unicode characters are transformed into something else > > entirely. Cheers, Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) ---
**Author:** ![peter\_812](https://avatars.discourse-cdn.com/v4/letter/p/b5ac83/32.png) [@peter\_812](https://forums.toadworld.com/u/peter_812)\ **Post date:** [June 15, 2011, 8:57am UTC](https://forums.toadworld.com/t/got-strange-characters-in-results-toad-10-6/10308/8 "2011-06-15T08:57:43Z")
I got it: on my machine are 2 oracle homes installed - 8.0.6 - 11g Toad made the 8.0.6 the default toad home and so I got the chinese characrters. When explicitly choosing 11g (and make this definitly to the toad home) it works. But without definitly choosing 11g as default toad changed the home to 8.0.6 the next time and I got zhe chinese characters. Peter