Toad World® Forums

Problem with special characters.

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

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

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