November 10th, 2003, 06:36 AM
Euro symbol appears like a '?' instead '€'
I have SQL Server 2000 SP3 and the default Code Page is:
Compatibility_42_409_30003 --> 850
I have a Table with a column of the type varchar(8000).
In this column sometimes it's necessari instroduce the euro symbol (€). Now, when we write this symbol, after the SQl Server show it with a '?'.
I Tried change the column collation to 'Latin1_General_CI_AI' --> 1252, but there is the same problem.
I tried too change the type of the column to nvarchar. It work fine, but then only can write 4000 characters into this column, because an unicode char are 2 bytes.
It's possible mantain the type varchar(8000), and to save and show the euro symbol?
November 14th, 2003, 12:27 PM
you could always switch to ntext