DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2000
    Pune, India



    By default we used "WE8ISO8859P1" character set for our databases. Since this characterset doesnot support to "Euro" currency symbol. We created new database withcharacter set "WE8ISO8859P15". But still when we enter record using ALT + 0128 and ALT + 164 we see "?" . Since SQL*PLUS and SVRMGRL doesn't support this character we used TOAD to insert record in the table. Before inserting record when we write command, we can see'Euro' sign but after inserting record, If I give Select statement to check inserted record I can see "?" . Please help us to solve thisproblem as early as possible. Please also tell us how to configure SQL*plusWorksheet to see this sign.

    Thanks & Regards

  2. #2
    Join Date
    Nov 2000
    Hi there.

    After our painful experiences with the storage of special characters in the db, this weekend I am altering my database. I am changing it to the we8mswin1252 which supports the euro currency.

    An important thing is to first check on the database if the record was stored with the special characters. Use the convert to check this, sometimes it might be stored and not be displayed right (use directly on db not thru client).

    The next thing the setting on your client is important, via which you run the load etc. Check on your client settings in the registry:::>>> the local machine, nls parameters.

    What version of Oracle do you use.?

    Good luck,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.