Toad World® Forums

error view XMLTYPE national chars


#1

Hi!
Don`t show content XMLTYPE in CLOB view with national chars (win1251). In ver 5.5 its work fine.

MaKJ


#2

Would you mind sending me the extracted DDL for the table please?
I did a quick test and none works correctly. 5.5 displays gibberish while 6 displays blank.

Gwen


#3

Example:

SELECT xmltype(’

c_date1 Начальная дата 2 ') FROM dual

if replace this string “Начальная дата” on english chars “Start date” all view correctliy.

“Начальная дата” - win1251

MaKJ


#4

Hi MarkJ

Sorry it takes me too long to reply. I can’t see any different between 5.5 and 6.0. Both of them display ‘???’ instead of the right string.

Gwen


#5

I`am test again with SQL Nav 6.0 and all work fine!