Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Values are returned as question marks.

276434May 16 2002
I have set up a UTF-8 database, on my english version of WinXP..

SELECT * FROM NLS_DATABASE_PARAMETERS;

.. shows this is correct - UTF8

I have set up NLS_LANG variable in windows, to be "American.America.UTF8"

Using SQL*Plus worksheet I can update a row in my database to contain chinese characters. I dont know what the chinese means, but I can copy and paste from another application, and the glyphs looks the same in the source and SQL*Plus worksheet.

I can then select the row ..

SELECT * FROM THETABLE WHERE THECOLUMN = '{CHINESECHARS}';

The correct row is returned, but the column is shown with just question marks, instead of the glyphs I expect.

(This also happens with the web application I am developing which also seems to return qurestion marks. (PHP not JSP))

Can anyone shed any light on this problem as I am completely stuck.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2002
Added on May 16 2002
7 comments
3,539 views