Click to See Complete Forum and Search --> : UTF8 character display in Xterm


spkumar4
July 29th, 2002, 07:26 PM
Hi,
I am having a problem with the display of UTF8 encoded strings in X term.

I am running Xterm from Hummingbird version 7.1 and I am trying to insert and retrieve swedish characters stored in UTF8 format from a UTF8 enabled
oracle database.

I am able to properly insert and retrieve swedish characters into the database if I use Xterm for all my queries. But when I do the RAWTOHEX oracle function
on the string that was inserted, it is showing me the UNICODE values for the strings instead of the UTF8 values. Also when we are trying to read this value
from a PC application it is showing bad characters like questoin mark(?) and boxes. This could be because the PC application is reading UNICODE values from the
database when it is expecting UTF8 values.

Secondly, when I am inserting the strings in the database from a PC application like SQL Plus for Windows, it is woking fine for our PC application. But my queries from
Xterm are returning invalid characters. Further, a RAWTOHEX in this case is properly returning UTF8 values of the string inserted.

Based on this, following is what I was able to conclude(Please correct me if I am wrong):
Xterm inserts and looks for UNICODE charactres in the database when trying to insert a multi byte character in the UTF8 enabled database.

Is there a way in which I can enter UTF8 values in the database from a xterm and properly read values that are stored in UTF8 format from the database.

Any help in this regard will be greately appreciated.

Thanks

Prashanth.