Windows Azure Platform Family of articles Catalog
In my previous article, I have described how to enable Azure SQL database to support Chinese:
SQL Azure (vii) T-SQL executed in SQL Azure database
The key steps are:
1. Use the default character set: SQL_Latin1_General_CP1_CI_AS
2. Display the Chinese field column, the type must be nvarchar
3. When inserting Chinese characters, precede the string with an uppercase letter N
But sometimes it's too much trouble to put all T-SQL statements in front of the string with a capital letter N.
Here is a simple way to introduce the author.
Here I introduce the use of ARM mode to create Azure SQL Database
1. Create a new server Name:leitestserver.database.chinacloudapi.cn
2. Then under this server, create a new database. Note Setting the character set to (Collation):sql_latin1_general_cp1_ci_as
3. Modify the appropriate firewall rules
4. Open SQL Server Management Studio and connect to the Azure SQL Database
Executing T-SQL statements
Create Tabledbo. Chnstudent (UniKeynvarchar( -) not NULL Primary Key Clustered, Studentnumberint Identity(1,1) not NULL, Valuenvarchar( -) not NULL,)GoInsert intoChnstudent (Unikey,value)Values ('fefc201f-67e8-484f-a931-e620dcda9d08','Xiao Zhang'),('6a987d4f-c9bf-4804-b5b5-e5223fc7ded7','Xiao Li'),('0e467495-d139-4550-bbc1-610cd8305cd0'N'Xiao Zhang'),('B7be884d-5650-460d-be60-c1585d3ce1de'N'Xiao Li')
5. View the results of the execution:
This allows you to enter a success, regardless of whether the insertion value is preceded by an uppercase N.
Azure SQL database (Azure SQL database) supports Chinese values