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

Damien Mattei mattei at oca.eu
Thu Nov 29 10:33:45 UTC 2018


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.

Damien.Mattei at unice.fr, Damien.Mattei at oca.eu, UNS / OCA / CNRS

More information about the Haskell-Cafe mailing list