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.
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.
__
Hi,
I have the same problem like you. Do you have a solution?
best regards,
Peter Anzenberger
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
The Toad Advisor (under the Help menu) will also tell you whether or not NLS_LANG is set properly
Message from: peter_812
I got it:
on my machine are 2 oracle homes installed
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
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?
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.
__
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
I got it:
on my machine are 2 oracle homes installed
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