MSSQL database Encoding

Think of a problem. The client uses Unicode encoding and the server uses Unicode encoding. However, to reduce the amount of data transmitted over the network, the data transmitted over the network is UTF-8 encoding. To be compatible with multiple languages, the database should adopt UTF-8 or Unicode encoding. However, I did not find the database encoding setting option for MSSQL. Cache. ba

Think of a problem. The client uses Unicode encoding and the server uses Unicode encoding. However, to reduce the amount of data transmitted over the network, the data transmitted over the network is UTF-8 encoding. To be compatible with multiple languages, the database should adopt UTF-8 or Unicode encoding. However, I did not find the database encoding setting option for MSSQL. Http://cache.ba

Think of a problem.

The client uses Unicode encoding and the server uses Unicode encoding. However, to reduce the amount of data transmitted over the network, the data transmitted over the network is UTF-8 encoding. To be compatible with multiple languages, the database should adopt UTF-8 or Unicode encoding. However, I did not find the database encoding setting option for MSSQL.

Http://cache.baidu.com/c? M = signature & p = c973c54ad7c71bf1_ea8f207f44 & user = baidu

SSMS --> database engine --> database attribute --> Option --> character set. modify it to the Chinese character set,

SQL code

USE [master]  GO  ALTER DATABASE [CSDN] COLLATE Chinese_PRC_CI_AS  GO

Temporarily handle this:

However, the system's default ANSI encoding has not encountered any problems.

By：zhanyonhu