Skip to main content
M
mohdmurtazaa0001
June 5, 2023
Question

Mismatch the value in tables after run query

  • June 5, 2023
  • 1 reply
  • 0 views

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

    1 reply

    nikhilcht188835
    nikhilcht188835
    June 5, 2023

    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é", ...)

    Terms & ConditionsAccessibility statement