#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    8
    Rep Power
    0

    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. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    21
    Rep Power
    0
    you could always switch to ntext

IMN logo majestic logo threadwatch logo seochat tools logo