Home » SQL & PL/SQL » Client Tools » Enabling UTF-8 format in Toad
Enabling UTF-8 format in Toad [message #262841] Tue, 28 August 2007 06:27 Go to next message
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
Re: Enabling UTF-8 format in Toad [message #262872 is a reply to message #262841] Tue, 28 August 2007 07:14 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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

icon9.gif  Re: Enabling UTF-8 format in Toad [message #262881 is a reply to message #262872] Tue, 28 August 2007 07:31 Go to previous messageGo to next message
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.

Re: Enabling UTF-8 format in Toad [message #262883 is a reply to message #262881] Tue, 28 August 2007 07:35 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check this blog; it is about Chinese characters, but you might get the idea.
Re: Enabling UTF-8 format in Toad [message #263702 is a reply to message #262883] Thu, 30 August 2007 16:20 Go to previous messageGo to next message
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...)
Re: Enabling UTF-8 format in Toad [message #263703 is a reply to message #263702] Thu, 30 August 2007 16:27 Go to previous messageGo to next message
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
Re: Enabling UTF-8 format in Toad [message #263704 is a reply to message #263703] Thu, 30 August 2007 16:30 Go to previous message
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.
Previous Topic: Adding a database to the Oracle Login
Next Topic: DBArtisan checking o/p
Goto Forum:
  


Current Time: Sun Dec 04 18:34:58 CST 2016

Total time taken to generate the page: 0.16620 seconds