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?

Thanks Again,
Prashanth.