[Haskell-cafe] Re: haskelldb + sqlite problem.

[GüŸnther Schmidt]

Hi Cloud,

this often occurs when the path to the database includes a non-ascii 
character.

In my dev environment, the path to the database deliberately contains an 
umlaut and the original code base of hdbc.sqlite3 from John Goerzen, 
version 2.0 & version 2.1 thus does not work.

John Goerzen, the author of HDBC has considerably rewritten some parts 
of his hdbc package to use utf8-string wrapping, which includes wrapping 
  the connection string, and in my case caused considerable problems, it 
just wouldn't work. So my solution was to rollback all these changes 
where he used the utf8-wrapping, which was quite a lot of work. I did 
communicate this to John, but he insists that his current solution is 
correct, and I'm not going to argue with him.

Anyway what you can do, for now, is to put your sqlite3 database file 
into a location where the path contains no non-ascii characters, that 
should fix the problem.


You may experience other, utf8-wrapping related problems, for instance 
when you want to insert non-ascii strings into varchar columns. They may 
not come back as you put them in.

HTH

Günther

Magicloud Magiclouds schrieb:
> Hi,
>   I am using haskelldb and haskelldb-hdbc-sqlite3. Well, I finally got
> the source compiled and ran, I got this error:
> App: user error (SQL error: SqlError {seState = "", seNativeError =
> 21, seErrorMsg = "prepare 74: SELECT subject,\n       timestamp\nFROM
> notes as T1\nORDER BY timestamp DESC: library routine called out of
> sequence"})
>   Any clue what I should check? Thanks.