Member Avatar for hitro456
hitro456 0 Light Poster

Hi folks,

I had mysql database with English+Chinese data in it...I had to migrate that database from mysql to MSSQL 2005. Now I cant view any chinese character..It shows '?' symbol in place of chinese characters.

How can I set the collation in MSSQL that I can view chinese data same way as english data.

Or

Create a new database which can take both inputs i.e. chinese and english.

Thanks in advance...

  • 1 Contributor
  • 0 Replies
  • 86 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.