# DBMS\_OUTPUT with special characters problem.

**URL:** <https://forums.toadworld.com/t/dbms-output-with-special-characters-problem/33988>\
**Category:** SQL Navigator\
**Created:** [August 27, 2015, 4:45am UTC](https://forums.toadworld.com/t/dbms-output-with-special-characters-problem/33988 "2015-08-27T04:45:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![martin\_goblet](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin_goblet/32/267_2.png) [@martin\_goblet](https://forums.toadworld.com/u/martin_goblet)\
**Post date:** [August 27, 2015, 4:45am UTC](https://forums.toadworld.com/t/dbms-output-with-special-characters-problem/33988/1 "2015-08-27T04:45:27Z")

</div>

Hi

The whole morning I was fighting with special characters. I need to import a UTF-8 file into our database, where the default charset is WE8MSWIN1252 and the secondary charset is AL32UTF8. I used the dbms\_output command to debug before inserting the 1300000 records into the database, and I got always reversed question marks on special characters like the bulgarian ones.

After a While, I've decided to insert the records (in NVARCHAR2 fields), because I absolutely needed them, and I was really surprised, that the reversed question marks had disappeared. Here a print screen of the records and the related dbms\_output lines

![0820.SQL Navigator 7.3.png](https://global.discourse-cdn.com/quest/original/2X/9/902e79dcd06d2a68653c5a77662ef360e733b6f3.png)

I searched if the DBMS\_OUTPUT command supports UTF-8, and found no indication it doesn't.

**So, is it SQL Nav that does not show the right characters in the output window, or an Oracle problem ?**

Sample text I used for the tests :

AT 8263 Großwilfersdorf Steiermark 06 Politischer Bezirk Hartberg-Fürstenfeld 622 Großwilfersdorf 62217 47.0833 15.9833 4

AT 8272 Nörning Steiermark 06 Politischer Bezirk Hartberg-Fürstenfeld 622 Ebersdorf 62209 47.2 15.95 4

BE 4032 Liège Chênée Wallonie WAL Liège Liège 50.6412 5.5718 3

BE 4120 Neupré Wallonie WAL Liège Liège 50.4952 5.5673 1

BG 8500 Айтос / Ajtos Бургас / Burgas BGS Айтос / Ajtos BGS01 BGS01-00 42.7 27.25 4

LT 75044 Žilių k. Šilalės r. sav. 55.5639 22.4514 3

LT 75044 Pelkės k. Šilalės r. sav. 55.5639 22.4514 3

LT 75044 Ąžuolijos k. Šilalės r. sav. 55.5639 22.4514 3

LT 75044 Pakalniškių k. Šilalės r. sav. 55.5639 22.4514 3

LT 75044 Mankiškės k. Šilalės r. sav. 55.5639 22.4514 3

MX 55840 Santa María Maquixco México MEX Teotihuacán 092 19.7255 -98.8998 1

MX 55840 Ampliación Ejidal Maquixco México MEX Teotihuacán 092 19.7255 -98.8998 1

PL 90-552 Łódź Łódzkie Łódź 51.75 19.4667 4

Regards

Martin

---

<div class="post-metadata">

**Author:** ![Alan.Yang](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@Alan.Yang](https://forums.toadworld.com/u/Alan.Yang)\
**Post date:** [August 28, 2015, 12:13am UTC](https://forums.toadworld.com/t/dbms-output-with-special-characters-problem/33988/2 "2015-08-28T00:13:20Z")

</div>

Hi Martin,

Thanks for your feedback, I reproduce it when I have changed NLS\_CHARACTERSET (change “AL32UTF8” to “WE8MSWIN1252”), so I’m afraid it as the same promble with SQLNAV-1915 ([www.toadworld.com/…/24708.aspx)](http://www.toadworld.com/products/sql-navigator/f/51/t/24708.aspx)), I will continue to focus on it.

Regards,

Alan

---

<div class="post-metadata">

**Author:** ![martin\_goblet](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin_goblet/32/267_2.png) [@martin\_goblet](https://forums.toadworld.com/u/martin_goblet)\
**Post date:** [August 28, 2015, 12:27am UTC](https://forums.toadworld.com/t/dbms-output-with-special-characters-problem/33988/3 "2015-08-28T00:27:21Z")

</div>

Hi Alan

Yes, I think both problems are related. Hopefully you’ll find a solution, because I lose a lot of time with those special characters problems.

Regards

Martin