Ascii character with code 193 returned as A in the grid

Toad for Oracle
1

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

2

When I run this query against a database with a character set of AL32UTF8, I get Á as a result and not A.

3

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.

4

@John: Our character set is US7ASCII. I think that explains why I get this behavior. Thanks

5

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.