• HDBC database: error on accent table name

    From damien.mattei@gmail.com@21:1/5 to All on Thu Nov 29 00:47:35 2018
    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,

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)