Toad World® Forums

Character data display problem

hi,

I’m using database 10.2 on server side and install oracle forms 6i on my system. Every thing is good with SQLPlus.

When I install toad 10.6.1.3 and connected to database and query data from any table, it is showing in boxes “㔰㜵㔰㜵㔰㜵” instead of character data.

Kindly suggest me what to do?

Thanks in Advance.

sadiq

Afternoon Sadiq,

I’m using database 10.2 on server side and install oracle forms 6i on my
system. Every thing is good with SQLPlus.
Oracle Forms 6i??? That’s ancient and doesn’t know Unicode. If I
remember it’s using an Oracle 8.0 client.

When I install toad 10.6.1.3 and connected to database and query data
from any table, it is showing in boxes “㔰㜵㔰㜵㔰㜵” instead of
character data.
I’d start by checking the fonts in use on your Toad. (See the thread on
“Running update statement through Sql Editor loses Unicode Characters”
elsewhere this week for details on exactly how) - make sure you are
using Courier New or Microsoft Sans Serif as they are able to display
Unicode.

Mind you, I suspect that the display of boxes is telling me that your
font is capable of displaying Unicode, but the characters it is getting
are invalid Unicode.

This really points the finger of total suspicion at your client. You
should install an Oracle 10g (32 bit) client on your desktop/laptop and
try again.

Oracle Forms 6i is way way way out of date. How do I know? I have to
deal with it at work on a daily basis. :frowning:


Cheers,
Norm. [TeamT]

My database version = 10.2.0.1.0
Client version = 8.0.6.0.0
toad version = 10.6.1.3

and result is attached as bmp file.

Kindly suggest what to do?

Thanks
sadiq

Before you do anything else – you need to upgrade your Oracle client to at
least 10.2 – neither Oracle or Quest support your configuration.

Jeff

Sadiq,

My database version = 10.2.0.1.0
Client version = 8.0.6.0.0
Oracle Forms 6i - as I said!

and result is attached as bmp file.
I see it, thanks.

Kindly suggest what to do?
As I mentioned in my previous reply, 8.0 client cannot do Unicode. I
suspect your database does and is using Unicode. Toad 10 can do Unicode
quite happily. However, the first Oracle Client that was able to do
Unicode was 9.1 or 9.2 but it was buggy in the extreme.

10g Client was about the first (stable) client that could handle Unicode
properly. You must upgrade your Oracle Client to one that handles
Unicode - 10.2 or higher would suffice.

One other point. As you have installed Forms 6i, I presume you may be
considering creating some application(s) that communicate with your 10g
database? If so, they too will suffer from the Unicode problem.

Two things I’d like you to do for me please:

  1. DESC RCV_TRANSACTIONS (the table in your bitmap).

  2. Try running your SELECT * FROM RCV_TRANSACTIONS in the version of
    SQL*Plus supplied under your Forms 6i installation. Does it give the
    correct data?

Thanks.

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

If you install Forms 8i then the default oracle home is changed to that one –
and that version of oracle client does not support unicode

As I replied to your earlier post – when you installed Oracle forms 6i it
changed the default home to its client which does not support Unicode. Simply
press the button on the toad connection screen next to oracle home and make sure
to point to the correct oracle home