Problem with special characters.

[martin_goblet]

Hi

I need to input some bulgarian and greek text into our database in a NVARCHAR2 field (in AL16UTF16).

Our charset is : NLS_CHARACTERSET : WE8MSWIN1252, NLS_NCHAR_CHARACTERSET : AL16UTF16

Database : NLS_RDBMS_VERSION : 11.2.0.4.0

SQL Nav : 7.3.0.4005 32 bit (tests even worth with v6.7)

My table is : toto(texte1 VARCHAR2(20 BYTE), texte2 VARCHAR2(20 BYTE), texte3 NVARCHAR2(2000))

I tried several things : encoding directly the texts within the editor in the database, creating a file containing the insert/updates, creating a procedure with the inserts/updates, ... Each time I do commit, I get this (in the table, or in the procedure) :

I saved the code in a file (UTF8). When I open this file in v6.7, I directly get the wrong characters, in V7.3 I see the right characters, but the insert/update does not work.

The code from the SQL file :

BEGIN

UPDATE toto SET texte3='Юници от следните планински породи:сива, кафява, жълта и петниста "Pinzgau", различни от предназначените за клане' WHERE texte1='BG';
UPDATE toto SET texte3='Δαμαλίδες, άλλες από εκείνες που προορίζονται για σφαγή, των ακολούθων ορεσιβίων φυλών: φαιά, καστανή, κίτρινη και με στίγματα του Pinzgau' WHERE texte1='EL';
UPDATE toto SET texte3='Génisses, autres que celles destinées à la boucherie, des races de montagne suivantes : grise, brune, jaune et tachetée du Pinzgau' WHERE texte1='FR';
COMMIT;

END;

Does SQLNav manage UTF8 or is it another problem ?

Regards

Martin

[Alan.Yang]

Hi Martin,

Thanks for your feedback, we have created a new story(SQLNAV-1915) for it.

As a alternative solution, alter the database’s character to “AL32UTF8” (NLS_CHARACTERSET = AL32UTF8), the special characters is fine, but change the character to “WE8MSWIN1252”, the problem as you see.

Regards

Alan

[martin_goblet]

Hi Alan

Can't change our (very huge) databases settings. It works fine in Oracle, because I'm able to load these characters with utl_file into the nvarchar2 fields :

The problem is when I've to maintain them with SQL Navigator :

I can't insert or update these fields with SQL Navigator.

Regards

Martin