SQLTeam.com | Weblogs | Forums

Special characters in an SQL query


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.

Could you help me please?

Thanks a lot

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