Special characters in an SQL query

Transact-SQL
1

Hello,

I have a SQL query which contains in the WHERE clause, this type of statement: INVENTTABLE.ITEMID=CUSTINVOICETRANS.ITEMID) IN ('PFHOZ','Négoce','PLVHOZ','PLVTUY','PFEXEL','Emb')
The text 'Négoce' contains an accent.
When I want to import the SQL file of the query into the SQL Management Studio Import Wizard, the "é" character is replaced by a symbol as in the attached image.
Copy/paste the query does not work because it is too long.

2022-11-10_10-01-08
2022-11-10_10-01-08793×105 2.83 KB

Could you help me please?

Thanks a lot

2

You need to save it with the proper encoding using save as and then selecting utf8 encoding