Why it inserts "?" instead of persian unicode characters?

Question

I am creating an ETL project, in which I want to move a table on an Oracle server into a table on a SQL Server.

I have a varchar2 column in Oracle, which I mapped to a varchar column in SQL Server.

But when I execute the ETL (using Microsoft BI), the data turn into "?".

The original data is persian unicode characters.

Use `nvarchar` or (possibly) change the collation if there is a suitable code page for the characters you want to store. — Martin Smith, Aug 11 '12 at 09:27

score 0 · Answer 1 · answered Aug 11 '12 at 09:37

0

Assuming the table name is some_table and the column name is some_column of size 100 characters for your SQL Server. Running the following T-SQL command should solve your problem:

ALTER TABLE some_table ALTER COLUMN some_column NVARCHAR(100)

answered Aug 11 '12 at 09:37

M. Ahmad Zafar

4,721
3
30
44

Why it inserts "?" instead of persian unicode characters?

1 Answers1