Got strange characters in results - TOAD 10.6

Toad for Oracle
1

We installed TOAD 10.6 and when I did test run, I noticed some columns showed some strange characters. For instance, currency code should be USD, but the result show something like 单D䜀U某๔_

Please advise on how to get ride of them. Thanks, NMA.

2

We installed TOAD 10.6 and when I did test run, I noticed
some columns showed some strange characters. For instance,
currency code should be USD, but the result show something
like 单D䜀U某๔_

Please advise on how to get ride of them. Thanks, NMA.

I suspect that your problem is the fact that TOAD now does UTF whereas your previous versions did not. You may be using a font that cannot display UTF characters. Try "Courier New" which can but "Courier" cannot.

If that doesn't resolve the problem, what is the NLS_LANG setting for your Oracle client and also, what is the database character set and nls_character_set.

Also, "select dump(column_name, 16) from table where ..." - column_name is the column holding the USD data, and the where clause should limit that to a few rows.

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

3

Hi Norm,

Thanks for your reply. I never check/setup TOAD language part. Please advise how to do that. There is no database change at all and both 9.0.1 and 10.6 use the same databases.

Thanks,
NMA

4

Sorry, missed this one. Apologies for the delay.

To check your client NLS_LANG settings, do the following:

  1. Start a DOS session. Type set nls_lang and press return. If you get
    “Environment variable nls_lang not defined” go to step 2. Otherwise, go
    to step 3.

  2. Start->run. Type regedit and click OK.

Navigate to HKLM/software/oracle/HOMEn. (n is the digit at the end of
the Oracle Home you are using. If you have more than one installed. Open
each one till you find the setting for ORACLE_HOME that matches the one
you use in Toad.)

Once in the correct HOMEn, look for NLS_LANG on the right side. There
should be a value in it. If so, go to step 3. Otherwise, I would say
that your client install is not correct.

  1. You have a value for NLS_LANG now, it is in three parts. My own
    setting for 11g client is “ENGLISH_UNITED KINGDOM.WE8MSWIN1252”. The
    three parts are:

ENGLISH - language.
UNITED KINGDOM - Territory.
WE8MSWIN1252 - Client character set.

Now we have some client values, we can check the database.

In Toad, connect to the database. You may need SYSTEM access for the
rest, but possibly not.

Run the SQL command “select * from v$nls_parameters;” you should get a
list of data coming back, some of which is as follows:

PARAMETER VALUE

5

I have a similar problem. I have set the NLS_LANG. Set regional settings in Windows. When I check regedit there appears to be no key for NLS_LANG. I tried the query for the select * from v$nls_parameters, but this also comes back looking like Japanese charicters. I have also tried modifying the font to UTF friendly courier new under data-grids visual, etc.
Are there some other things I can try?

6

Dears,

plese i have the same problem , the data grid show as 췣쿣쿦촠유췑

can help me?

regards ,

7

You may want to look at some of the blog posts on this subject:

www.toadworld.com/…/identifying-the-source-of-potential-unicode-issues-in-toad-174-for-oracle

www.toadworld.com/…/what-is-unicode-part-1

www.toadworld.com/…/what-is-unicode-part-2

From: m.aerhil [mailto:bounce-maerhil@toadworld.com]

Sent: Monday, May 02, 2016 8:07 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Got strange characters in results - TOAD 10.6

RE: Got strange characters in results - TOAD 10.6

Reply by m.aerhil

dears

plese i have the same problem , the data grid show as 췣쿣쿦촠유췑

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

8

Many have seen this problem go away just by installing a newer Oracle client.