About the processing of language and special characters when SQL Server inserts data

Problem Description:

When inserting or modifying data, when there are (Korean, Japanese) or other characters in the inserted (modified) field, the inserted characters become garbled or piles of question marks.

Workaround:

In Microsoft SQL Server , The following data types support Unicode data:

nchar, nvarchar, ntext

You should be aware of the following issues when using SQL statement operations:

Original query statement

Select * from TABLENAME Where field1 like '%xxx% '

For a Unicode data type , it should be :

Select * from TABLENAME Where field1 like N '%xxx% '

Insert data as well

INSERT into TABLENAME (Detail) VALUES ('????? ')

Revision changed to

INSERT into TABLENAME (Detail) VALUES (N '????? ')

Otherwise, the Hangul is inserted into the database and becomes a question mark -_-

About the processing of language and special characters when SQL Server inserts data