|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
November 10th, 2003, 05: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? Thanks, Eva Janakieff
|
|
#2
November 14th, 2003, 11:27 AM
|
|||
|
|||
|
you could always switch to ntext
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Euro symbol appears like a '?' instead '€' |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
