OraFAQ Forum: Client Tools » Enabling UTF-8 format in Toad

Home » Other » Client Tools » Enabling UTF-8 format in Toad

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Enabling UTF-8 format in Toad [message #262841]

Tue, 28 August 2007 06:27

anilgovindaiah
Messages: 2
Registered: August 2007

Junior Member

Dear friends,
I have Toad for Oracle 9.0 installed on XP professional and have Oracle 10.2.0.3.0. I have Russian characters in my DB and I need to view the same in Toad data grid. but how can I enable the same? Please suggest me the navigation path also to achieve the same.

Thanks
Anil

Report message to a moderator

Re: Enabling UTF-8 format in Toad [message #262872 is a reply to message #262841]

Tue, 28 August 2007 07:14

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try to see what has been said in the Global Operation section of the TOAD 8.6.1 release notes. Here's what 9.0 says about it.

[Updated on: Tue, 28 August 2007 07:16]

Report message to a moderator

Re: Enabling UTF-8 format in Toad [message #262881 is a reply to message #262872]

Tue, 28 August 2007 07:31

anilgovindaiah
Messages: 2
Registered: August 2007

Junior Member

Hi,
below is the excerpt from 9.0 documentation:

Toad's data layer does not support UTF8 / Unicode data. Most non-ASCII characters will display as question marks in the data grid and should not produce any conversion errors except in TOAD Reports. TOAD Reports will produce errors and will not run on UTF8 / Unicode databases. It is therefore not advisable to edit non-ASCII Unicode data in Toad's data grids

I guess it says, I cannot see the actual literal over the data grid [:(].

In that case, please suggest if you know any other product which supports.

Thanks
Anil

P.S: I tried using putty, the telnet application, I cld see the characters with modifying the translation as UTF-8.

Report message to a moderator

Re: Enabling UTF-8 format in Toad [message #262883 is a reply to message #262881]

Tue, 28 August 2007 07:35

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Check this blog; it is about Chinese characters, but you might get the idea.

Report message to a moderator

Re: Enabling UTF-8 format in Toad [message #263702 is a reply to message #262883]

Thu, 30 August 2007 16:20

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Try the brower based iSQLplus or maybe Oracle XE interface. Browsers were designed with lots of characterset support. In my experience, iSQLplus doesn't show all my UTF-8 encoded Uincode characters, but does a pretty good job.

Also - before blaming the browser for not handling all your characters, you need to be very careful to ensure you have a compatible characterset set in your "client" app. and that the characters are stored correctly in the DB (select dump(mycol, 1010), dump(mycol, 1016) from...)

Report message to a moderator

Re: Enabling UTF-8 format in Toad [message #263703 is a reply to message #263702]

Thu, 30 August 2007 16:27

andrew again
Messages: 2577
Registered: March 2000

Senior Member

you could also try a trick like creating a DB link form Ora9 to Ora8 and then access the Ora8 data from Ora9 using SQL Developer

Report message to a moderator

Re: Enabling UTF-8 format in Toad [message #263704 is a reply to message #263703]

Thu, 30 August 2007 16:30

andrew again
Messages: 2577
Registered: March 2000

Senior Member

BTW - the reason SQL Developer displays UTF-8 is probably because it's Java based rather than by some specific effort by the dev team <<pure speculation of course>>. Java was designed with comprehensive characterset support in mind.

Report message to a moderator

Previous Topic:	Adding a database to the Oracle Login
Next Topic:	DBArtisan checking o/p

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 06:25:09 CDT 2024