Inserting Values with ticks in a SQL-Field

[PMan]

Hi,

how can I insert and update SQL-Field with values with a tick like "Côte d'Ivoire" or " don't"?

Using

.... Set Country = 'Côte d'Ivoire' , ...

don't work because of the three ticks in the statament.

/PMan

[Henning]

In MySQL that is \' (backslash tick).

There are several ways to include quote characters within a string:

A “'” inside a string quoted with “'” may be written as “''”.

A “"” inside a string quoted with “"” may be written as “""”.

Precede the quote character by an escape character (“\”).

A “'” inside a string quoted with “"” needs no special treatment and need not be doubled or escaped. In the same way, “"” inside a string quoted with “'” needs no special treatment.


/Henning