Problem with Unicode data

• rajeev_vandakar-782919

  SSC Eights!

  Points: 871

  More actions

  December 1, 2009 at 6:17 am

  #139750

  Hi,

  We have some database in MS Access with data in Unicode (in Kannada language) data in multiple columns. With Access, these columns are readable easily. But when I port this database to MS SQL (either 2000 or 2005), these columns can not be read. Characters are shown as boxes. The data type for these columns is nvarchar only. What may be the problem here?How to enable the SQL server (either 2000 or 2005) to support Unicode data?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  December 1, 2009 at 6:26 am

  #1085732

  Double posted, please reply here.