Our Oracle database is running in WE8ISO8859P1 character set
that does not support Euro symbols. I have to insert some data in a
table with Euro symbol(s) in one of the columns and retrieve the same using select statement. The client network terminal is not supporting
Euro symbols due to which it retrieved some junk value....what are the
things to be done at database side/client side to get back the euro
symbol while selecting the data?
FYI, WE8ISO8859P15 supports the Euro symbols and its binary code is 164.
First of all as ur saying that your database does not support EURO symbol, then how can u insert a EURO symbol and retrive the same.
your database character set must be a super set or the same charater set of your client.
First make sure that your database supports EURO symbol by changing the character set of the DB and do the same on the client.
Thanks for your reply. Clio-As you understood, my database doesn't support EURO symbols, but i have to insert EURO symbols in one of the table & be able to retrive the same. One option is that I export the database, recreate the database again with the character set that supports Euro characters and then import the same. I dont want to do all that. so could you tell me now what other options are available to acheiev my requirement?