UTF-8 and PLSQLDev

[Joy Patra]

Hi,

I've Oracle 8.1.7, database is in charset American_America.UTF8.

I've set NLS_LANG env to American_America.UTF8 on my client machine.

When I try to enter data into tables using Edit Data grid, I get a "Character set mismatch" error.

What should I set to make this work?

Thanks,
Joy

 

[Joy Patra]

Hello, Sorry I forgot to add that the columns in the tables are NCHAR and NVARCHAR2.

Cheers, Joy

 

[Marco Kalter]

Can you send me a screenshot by e-mail with this error?

 

[Rich Leach]

.... just wanted to post some more info about this issue:
We have been encountering similar issues with our system (Cold Fusion, specifically) and PL/SQL Developer. Whenever we entered data to our tables via PL/SQL Developer, and then attempted to query those records via Cold Fusion which uses a JDBC-Oracle driver, we'd get "Transliteration failed, reason: invalid UTF8 data". The characters would look fine in the PL/SQL Developer grid but would be unrecognizable to our Cold Fusion system! If we submit the data via Cold Fusion (through the JDBC driver) and then query it the select comes back sucessfully. Sounds like if other people are getting "Character set mismatch" errors that there could be an issue or setting that needs attention to this tool.... Did we miss a setting or a config file somewhere?

Hope this helps!

rich

Originally posted by Joy Patra:
Hi,

I've Oracle 8.1.7, database is in charset American_America.UTF8.

I've set NLS_LANG env to American_America.UTF8 on my client machine.

When I try to enter data into tables using Edit Data grid, I get a "Character set mismatch" error.

What should I set to make this work?

Thanks,
Joy

 

[Joy Patra]

Some more info:

Same problem using Toad.

In both PL/SQL Developer & Toad, using SQL editor to execute the SQL statement (with strings put in like N'yes') works.

The problem is only with grids.

It works with DBA Studio though. In grid, you type in N'yeah' instead of just yeah, and it handles it correctly.

So for now, it's back to DBA Studio from these tools!

Thanks,
Joy