Problem with Unicode characters

[cspm2003]

Hello,

I have a problem inserting unicode characters into my database. The database uses the UTF8 character set and the character I want to insert is:
&#8218

Now, instead of this, a reverse question mark gets inserted. I searched google, but couldnt find a solution for my problem.

 

[hoinz]

Hello,

there are a few questions first:

Which tool / which command are you using for inserting?

What makes you believe that a reverse question mark gets inserted ?
Maybe the character gets inserted correctly, but your query tool is not capable of Unicode and gives you a reverse question mark when you select.
To verify this, please use dump function, something like:
select dump(my_inserted_column,16) from my_table where <whatever>

regards

 

[cspm2003]

Hello hoinz,

- I am using Apache Phoenix for the insert.

- I looked on the table with PL/SQL Developer, which should be able to read the character

Also, I have written a small java application, that inserts the same character into the table, I dont get a reverse question mark this time, but instead something like "ab

 

[hoinz]

Hi,

unfortunately I am not familiar with Apache Phoenix, nor Developer, nor Java.
Perhaps somebody else will be of more help here.

But nevertheless I think the most reliable method of finding out which bytes are stored in a table is dump function, as mentioned above.

regards

 

[cspm2003]

Just for information of others:

The solution of the problem was, that the table had to be in the nvarchar2 format, and the insert had to be done using the unistr() funktion, then it worked

cheers