Mismatch the value in tables after run query

Question

Hello,

I am trying to write an INSERT query

The INSERT query is of the form INSERT INTO <table_name> (..., <VARCHAR FIELD>,....) VALUES (...,'Completed/Terminé', ...)"

the word Terminé is the french word after run this query the value inserting in the table is Termin? instead of Terminé

Plzz suggest me the solution

Nikhil Tetali · Answer

Hi, Use double qourts rather than single qourts as illustrated below, but using single qourts also correct format only... INSERT INTO (..., ,....) VALUES (...,"Completed/Terminé", ...)