View previous topic :: View next topic
|
Author |
Message |
Sandeep D. Patil
New User
Joined: 29 Jun 2008 Posts: 23 Location: mumbai
|
|
|
|
Hi,
I tried to insert some currency symbols '$', '£' and '€' in DB2 table(Column defined as CHAR(2)) using QMF. '$' and '£' symbols got inserted successfully, but not able to insert Euro '€' symbol. It's not even getting displayed on the Mainframe screen.
Some of the symbols are displayed as '?'.
How can we store currency symbols in DB2 table?
Regards,
Sandeep |
|
Back to top |
|
|
knn9413
New User
Joined: 23 Jul 2009 Posts: 17 Location: US
|
|
|
|
If I am not mistaken for the Euro, you would need to alter the CCSID at the database level. I am not a DBA so don't know the specifics but I do remember reading that somewhere |
|
Back to top |
|
|
knn9413
New User
Joined: 23 Jul 2009 Posts: 17 Location: US
|
|
|
|
trying casting it along with the ccsid and you might be able to execute it in the query |
|
Back to top |
|
|
|