Insert into student1
Values (' wang2 xiao3 er4, 19,98,101)
Select * from student1

The running result is as follows,
Xiao Ming 18 99.00 101
1Two roaches 18 89.00 102
Three small friends 19 98.00 103
Four little red 17 97.00 104
5 xiaoqi 19 97.00 105
6??? 19, 98.00 101
7??? 19, 98.00 101
8??? 19, 98.00 101
9 19 98.00 101 1
10 1 19 98.00 101

Instead of inserting wang2 xiao3 er4, name???

CodePudding user response:

The alter database database name collate Chinese_PRC_CI_AS

CodePudding user response:

 insert into student1 values (N 'wang2 xiao3 er4', 19,98,101) 

Add a N try,

If not, you posted your table structure,