UTF 8 Behaviour

[icalvin]

Hello,

we are testing the new PL/SQL developer UTF8 new features. As we can see, we can read utf8 content in the grid result.
But the next test doest work fine:
We go and copy some Polish text with a lot of polish chars (like Źł .. etc). Them, we paste this text into a "insert" statement and we commit it. After that, we can run a query in order to check the insert result and we can see that this chars are not right inserted!
it is a normal behaviour?
The DATABASE NLS parameters are:
NLS_CHARACTERSET = AL32UTF8
NLS_NCHAR_CHARACTERSET=AL16UTF16

and our NLS_LANG values in our machine are:
WE8MSWIN1252

than ou for your help.

best regards,
Nacho

 

[Marco Kalter]

Which PL/SQL Developer version are you using?

 

[icalvin]

Hello Marco,

we are using Version 7.1.1.1339 Pl/SQL

Thank you for your time,

best regards,
Nacho

 

[Marco Kalter]

In that case it should work fine. Can you let me know what the original Polish text is, and what the results are after requerying?

 

[icalvin]

Hello Marco,
we can solve the case. We update the nls_lang variable to _.AL32UTF8 value and works fine.

Now we have another issue regarding the open file format.. but we need to investigate more about it before open a new thread.

We start our company internal procedure in order to buy the upgrade PL-SQL (from 5.x to 7.x).

Thank you for your time and support.

regards,

 

[jifei]

I Have same problem,
insert into table, on oracle sqlplus show is error.

 

[jifei]

I use chinese , Server is al32utf8,in pl/sql , whether in NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK or NLS_LANG=AMERICAN_AMERICA.AL32UTF8,insert the table's data ,utl_raw.cast_to_raw is show same.

I oracle is 9.0.2

 

[YuL]

I have a problem. When I Query or Edit data of any table in PL/SQL Developer I had only Oracle error ORA-24328 illegal attribute value"

PL/SQL Developer
Version 7.1.4.1389
11.44165 - 5 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)
Using on client and server both
Home: OraHome81
DLL: c:\Oracle\Ora81\bin\oci.dll
OCI: Version 8.0
Oracle8i Release 8.1.5.0.0

Character Sets
Character size: 3 byte(s)
CharSetID: 871
NCharSetID: 0
Unicode Support: True
NLS_LANG: AMERICAN_CIS.CL8MSWIN1251
NLS_CHARACTERSET: UTF8
NLS_NCHAR_CHARACTERSET: UTF8

 

[Marco Kalter]

Can you upgrade to a 9.0 or later client and try again?

 

[YuL]

No, I can't.
My customers work with 8i only and our support service have to use this version.