[Haskell-cafe] HDBC database: error on accent table name

[Damien Mattei]

Hi,

i have this error:
*** Exception: SqlError {seState = "", seNativeError = 1064, seErrorMsg
= "You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use
near 'es where Nom = 'A 20'' at line 1"}

when doing this :

rows_coordonnees <- quickQuery' conn "select * from sidonie.Coordonnées
where Nom = 'A 20'" []

it seems tha the tabel name: Coordonnées that contain an accent is
causing serious problem to the parser at some point, if i use a table
name without accent it works fine.

i'm at the point to rename the table which have great impact on all the
project build with many other languages (Scheme) that deal correctly the
table name with accent.

any idea? to make accent works with haskell.

Regards,
Damien