var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Question: Euro symbol appears like a '?' instead ''
I have SQL Server 2000 SP3 and the default Code Page is:
I have a Table with a column of the type 'text'.
In this column sometimes it's necessary introduce 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', SQL_Latin1_General_CP1_CI_AI and SQL_Latin1_General_CP850_CI_AI but there is the same problem.
Does any know what the cause off this problem is?
Thanks in advance!
Last edited by Pedr0; 04-06-04 at 07:18.
The problem may well be a conflict between your SQL Server code page and the client machine code page. Characters that don't convert are rendered as question marks.
The MSDN page on SQL Internationalization might help clarify things for you (then agian, it might not).
You might try using NVARCHAR columns to see if that helps, but you may be forced to use another client (or possibly a web server) to see the Euro symbols.
THX, I will look into it!