Special characters replaced with question mark


I have some characters like ( š, ž etc) which are typical for my native language. I have a list of words in Excel file and then I tried to move it to SQL table. I saved Excel file as CSV file and then imported flat file into SQL table. I found out that all my characters that I listed above were replaced with "?". I don't understand what I did wrong.

Make sure the columns you are importing into are nvarchar, so that they support Unicode characters. Also check you transformations. I'm assuming SSIS if you are using the SSMS Import Data function. Make sure that the transformations and the column mappings are not converting to varchar/ANSI/ASCII character encodings.

1 Like