DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: character set WE8ISO8859P15 giving problem

  1. #1
    Join Date
    Jun 2003
    Location
    India
    Posts
    118

    character set WE8ISO8859P15 giving problem

    Hi

    One of our client at Germany used character set WE8ISO8859P15. Evrything is ok but he is not able to save the euro symbol in the database.

    I have read some where that the character set WE8ISO8859P15 does not support euro symbol, because euro symbol has value 164.

    The platform is Linux 8 with Oracle 8i.

    There is a sql function 'Convert' which can convert microsoft charcter set 'WE8MSWIN1252' to euro complitble.

    My questions are

    1. Which Character set supports Euro symbol. ?
    2. Is there any function which can make euro symbol comptible with
    WE8ISO8859P15 character set.
    3. Is there any other method to change charcterset without
    recreating the database.
    4. There is a utility 'CSSCAN' which can tell in which user.table
    unsupported charcters exsit. Is there any other tool
    like 'CSSCAN' for characterset.

    Thanks

    Vishal Sood
    vishal sood
    OCP 8

  2. #2
    Join Date
    Feb 2004
    Location
    Sweden, Karlstad
    Posts
    6
    Hi Vishal,

    Trying to see this scenario a bit clearer...

    One of our client at Germany used character set WE8ISO8859P15. Evrything is ok but he is not able to save the euro symbol in the database.
    How do you know that this is the character set in use?

    What character set does the client (application) use?

    How and what happens when he saves the euro char?

    I have read some where that the character set WE8ISO8859P15 does not support euro symbol, because euro symbol has value 164.
    ISO Latin 9 (8859-15) includes euro character and it's code happen to be 164. (http://www.cs.tut.fi/~jkorpela/latin9.html)


    Your questions:
    1. In Oracle, *MSWIN125x and WE8ISO8859P15 (the Latin "euro" set)
    2. see answer to 1
    3. Why do you want to change db character set?
    4. Isn't csscan for checking character set?

    Any thing else I've missed?


    Btw, this is my first forums post! Hope I did ok

    Fredrik.
    Oh! Look! A nerd... and some nerdlings!

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