Azure SQL database (Azure SQL database) supports Chinese values

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