Language settings - Collation, Unicode, UTF-8 etc

• r5d4

  SSCrazy

  Points: 2523

  More actions

  November 19, 2008 at 6:20 am

  #124954

  I now have the requirement to store Unicode UTF-8 data (japanese characters in our case) in our databases (server and database collations are currently the default of Latin1_General_CI_AS).

  From what i can gather SQL 7 / 2000 stores unicode in UCS-2. Is this still the case in SQL 2005 / 2008?

  I know I'll be using NVarchar columns to cope with unicode.

  Do any choices I make e.g; collation, codepage affect unicode storage?

  Has anyone encountered this before?

  thanks

  r

• CrazyMan

  SSChampion

  Points: 12560

  More actions

  November 19, 2008 at 7:19 am

  #900504

  I have faced this problem earlier, all i did is to change the datatype to unicode, we use java applications, its was working fine. 🙂