UNICODE shows "?????" in DB2 Control Center Console

[silvery]

Hello All,

I'm facing a problem while inserting unicode value in DB2 through DB2 Control Center. The following insert statement was issued.

INSERT INTO EMPLOYEE (ID, DATE, ADDRESS, EMPCODE) VALUES (1, '2003-11-29', '?????', 2);

But after paste, in the Control center console it shows

INSERT INTO EMPLOYEE (ID, DATE, ADDRESS, EMPCODE) VALUES (1, '2003-11-29', '?????', 2);

The unicode characters converted to "???" and after executing the statement, naturally it saves ??? in the database. Is there any way to overcome this problem? TIA.

 

[juliane26]

silvery,

i guess your original statement is still missing ...

Juliane

 

[silvery]

Sorry..I paste it correctly..but i turned it into ???
Anyway, trying again..

INSERT INTO EMPLOYEE (ID, DATE, ADDRESS, EMPCODE) VALUES (1, '2003-11-29', '?????', 2);

 

[silvery]

Opps!! Its still not showing properly..
It was showing the font properly even in the "Preview post"
Forget it..u can take any unicode character..

or you can click the link

http://www.dbforums.com/showthread.php?p=4479802

here, its showing properly..TIA..

 

[juliane26]

silvery,

we did have similar problems when using unicode and euro enabled databases with java GUIs (in our case a browser based application)

finally the reason was that the browser and java code page for the application had to be specified unicode as well.

for a browser application this might be still possible - once we knew the problem it was solved by our java folks, but dunno about the control center ... i can imagine it picks up your local settings from windows

One test: Without GUIs you can see and process your data correctly (russian or greek) ?

Juliane