# Character data display problem **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [September 23, 2011, 7:21am UTC](https://forums.toadworld.com/t/character-data-display-problem/10703 "2011-09-23T07:21:49Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![sadiq106\_421](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@sadiq106\_421](https://forums.toadworld.com/u/sadiq106_421)\ **Post date:** [September 23, 2011, 7:21am UTC](https://forums.toadworld.com/t/character-data-display-problem/10703/1 "2011-09-23T07:21:49Z")
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 ---
**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:** [September 23, 2011, 7:32am UTC](https://forums.toadworld.com/t/character-data-display-problem/10703/2 "2011-09-23T07:32:08Z")
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. ☹ -- Cheers, Norm. [TeamT] ---
**Author:** ![sadiq106\_421](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@sadiq106\_421](https://forums.toadworld.com/u/sadiq106_421)\ **Post date:** [September 23, 2011, 8:08am UTC](https://forums.toadworld.com/t/character-data-display-problem/10703/3 "2011-09-23T08:08:57Z")
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 ![DisplayError.bmp](https://global.discourse-cdn.com/quest/original/2X/c/c6d44a17129ba2e179f53e40db38a0ecc08522c3.bmp) ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [September 23, 2011, 8:08am UTC](https://forums.toadworld.com/t/character-data-display-problem/10703/4 "2011-09-23T08:08:57Z")
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 ---
**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:** [September 23, 2011, 8:09am UTC](https://forums.toadworld.com/t/character-data-display-problem/10703/5 "2011-09-23T08:09:39Z")
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](http://www.environment-agency.gov.uk) ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [September 23, 2011, 8:12am UTC](https://forums.toadworld.com/t/character-data-display-problem/10703/6 "2011-09-23T08:12:15Z")
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 ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [September 23, 2011, 8:14am UTC](https://forums.toadworld.com/t/character-data-display-problem/10703/7 "2011-09-23T08:14:51Z")
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