Hello,I am trying to write an INSERT queryThe 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
Discussion posts and replies are publicly visible
Hi,
Use double qourts rather than single qourts as illustrated below, but using single qourts also correct format only...
INSERT INTO <table_name> (..., <VARCHAR FIELD>,....) VALUES (...,"Completed/Terminé", ...)