Hello:
I am using Toad 12.7. When I run this query:
select ‘Á’ as fld from dual
The grid displays A and not the character with the ASCII code 193.
Furthermore, if I export the data to text file I get A as well
Is there a way to tell Toad to return in the grid the right character and for the export to work properly?
Thanks
When I run this query against a database with a character set of AL32UTF8, I get Á as a result and not A.
ok, found the answer:
select chr(193 USING NCHAR_CS) as fld from dual
This works fine. So, it’s not an issue of Toad.
@John: Our character set is US7ASCII. I think that explains why I get this behavior. Thanks
Evening Bog,
Sounds like the font you are using to display results in the grid is unable to display unicode (Ha ha, my spell checker wants that to be unicorn) characters.
Try setting the font to something that can handle unicode such as Courier New, perhaps. In Toads settings of course!
Cheers,
Norm [ TeamT ]
On 17 July 2015 22:57:14 BST, bog bounce-bogdanc@toadworld.com wrote:
Ascii character with code 193 returned as A in the grid
Thread created by bog
Hello:
I am using Toad 12.7. When I run this query:
select 'Á' as fld from dual
The grid displays A and not the character with the ASCII code 193.
Furthermore, if export the data I get A.
Is there a way to tell Toad to return in the grid the right character and for the export to work properly?
Thanks
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.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.