how to insert unicode text to SQL Server from query window

Question

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

I'm using the following code:

INSERT INTO tForeignLanguage ([Name]) VALUES ('Араб')

this value inserted like this '????'

How do I insert unicode text from the sql management studio query window?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

1 Answer

深蓝 · Answer 1 · 2021-10-17T00:32:32+0000

The following should work, N indicates a "Unicode constant string" in MSSQL:

INSERT INTO tForeignLanguage ([Name]) VALUES (N'Араб')