[Haskell-cafe] hsql-mysql encoding issues

[Daniel van den Eijkel]

Hi,

I can't say anything about HSQL, but I use HDBC and I'm happy with it. 
[1] says it's the most popular database for Haskell.
Best, Daniel

[1] http://en.wikibooks.org/wiki/Haskell/Database


Am 10/23/12 4:21 PM, schrieb Johannes Waldmann:
> Hi.
>
> I am using hsql-(mysql-)1.8.2
> When compiled with ghc-7.6, the resulting executable
> does not seem to be able to read strings from the DB correctly
> (umlauts do "vanish")
> while it  worked with hsql-(mysql-)1.8.1 and ghc-7.4.
>
> the mysql server says (show variables)
>
> | character_set_client            | latin1                      |
> | character_set_connection        | latin1                      |
> | character_set_database          | latin1                      |
> | character_set_filesystem        | binary                      |
> | character_set_results           | latin1                      |
> | character_set_server            | latin1                      |
> | character_set_system            | utf8                        |
>
> hsql is using type String all over the place,
> while it should be ByteString?
>
> Internally, Database.HSQL.Types.SqlBind
> uses Foreign.C.String.peekCStringLen .
> Did the behaviour of this function change?
>
> hsql is quite old, but so is my application.
> Assuming I find the time to rewrite my code (not likely) -
> what DB binding should I rather be using?
>
> Thanks - J.W.
>
>
>
> _______________________________________________
> Haskell-Cafe mailing list
> Haskell-Cafe at haskell.org
> http://www.haskell.org/mailman/listinfo/haskell-cafe
>