How to store Non-English Characters into SQL Table?

Question

Hi,

I have a table called Person_Data where 4 columns. Column3 has NVARCHAR(200) data type in which I want to store both English and Non-English data.

When I trying to Insert values manually into the table with preceding N' like below:

INSERT INTO dbo.Person_Data

( Col1, Col2, Col3, Col4)

VALUES (123, ABC, N'元気ですか', NULL)

Non -English characters loaded perfectly and successfully.

When I remove N' while inserting, i will get question marks (?) instead of Non-English.

I want to get Non-English value as it is.

I have CSV file having thousands of rows consisting this data. Is it possible to create SSIS package or any other alternative to load Non-English characters?

Answer 1

I have CSV file having thousands of rows consisting this data. Is it possible to create SSIS package or any other alternative to load Non-English characters?

Parameterized queries are typically used in SSIS and application code. This will preserve non-ANSI characters as long as parameter definitions specify data type nvarchar. The N prefix needed in T-SQL constants to denote a string of national characters does not apply to parameters.

SSIS will detect the nvarchar column type at design time with a OLE DB destination and parameterize the bulk insert accordingly.

Answer 2

Hi @Ramana Kopparapu,

First of all make sure that your CSV files are in the Unicode encoding (try to open CSV file in the Notepad-> Save As -> and check Encoding in the bottom). If they are not - save them in Unicode

And make sure that in the properties inside SSIS packege the check box is selectedFlat File SourceUnicode

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.