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

Hi Vishal,

Trying to see this scenario a bit clearer...

Quote:

---

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?

Quote:

---

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.