what is equivalent of utf-8 database characterset in sqlserver 2000

• sri-193551

  Newbie

  Points: 5

  More actions

  December 3, 2004 at 1:23 am

  #84951

  Hi,

  I have been working with oracle databases.

  If i want to setup a database which will accept any language in the world, i used to setup the database characterset at utf-8 and this would allow to store information in any language in the world.

  I am new to sql server 2000.

  I want to install a Sql server 2000 instance and database and want to setup the characterset like utf-8 which would allow to store any langauge character set.

  Can anyone tell me what is the equivalent database characterset for UTF-8 in Sql server2000 and how can i set it in sql server 2000.

  Thanks

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  December 3, 2004 at 2:10 pm

  #532544

  Have a look at Unicode and its' datatypes in BOL.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]