How to store euro currency symbol?

I have a problem to store Euro symbol "€" in the MS SQL 2000 database: it is
stored as "?".
The database default collation used is 'SQL_latin1_General_CP1_CI_AS (code
page 1252)". This doesn't support euro symbol. I found the only standard
character set that contains euro is "Latin-9 (ISO-8859-15)", Latin1 doesn't.
There's also an article describes the international feature of MS SQL server
2000
<http://msdn.microsoft.com/library/de...server2000.asp>
However I didn't find which specific collation or code page support Euro
symbol from this article, all it says is any column of 'money' or
'smallmoney' type can include a currency symbol such as euro "€"
Does any body know which collation of MS SQL 2000 support euro symbol?
Does the column type has to be "money" to store it?
How do I store it?
Thx
Hi Tina,
I do not have any problems in storing the Euro symbol in my database with
the SQL_latin1_General_CP1_CI_AS collation.
How do you insert the euro symbol into your record?
HTH
Karl Gram
"Tina" <Tina@.discussions.microsoft.com> wrote in message
news:3E881A78-5D70-4319-9FEB-B0C91795370D@.microsoft.com...
>I have a problem to store Euro symbol "?" in the MS SQL 2000 database: it
>is
> stored as "?".
> The database default collation used is 'SQL_latin1_General_CP1_CI_AS (code
> page 1252)". This doesn't support euro symbol. I found the only standard
> character set that contains euro is "Latin-9 (ISO-8859-15)", Latin1
> doesn't.
> There's also an article describes the international feature of MS SQL
> server
> 2000
> <http://msdn.microsoft.com/library/de...server2000.asp>
> However I didn't find which specific collation or code page support Euro
> symbol from this article, all it says is any column of 'money' or
> 'smallmoney' type can include a currency symbol such as euro "?"
> Does any body know which collation of MS SQL 2000 support euro symbol?
> Does the column type has to be "money" to store it?
> How do I store it?
> Thx
>