Post reply

Character sets

  • October 16, 2003 at 8:44 am

    #81240

    I've got a SQL 2000 database and am trying to store the 'ŷ' character in a varchar field. Whenever I view it, it appears as a plain 'y'. I'm using the collation "sql_latin1_general_cp1_ci_as". Anyone know what I can do, or how I can find what characters I can use in SQL 2000?

  • October 16, 2003 at 8:58 am

    #478489

    Try to define the column as nvarchar (Unicode data).

  • October 16, 2003 at 9:06 am

    #478491

    Got it working. Used a nvarchar, and an N before the string to identify it as unicode.

    Cheers

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply