[Mono-bugs] [Bug 77711][Maj] Changed - Mono.Data.SqliteClient throws exception retrieving non-ASCII data

[bugzilla-daemon at bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by tauberer at for.net.

http://bugzilla.ximian.com/show_bug.cgi?id=77711

--- shadow/77711	2006-03-08 09:04:45.000000000 -0500
+++ shadow/77711.tmp.19191	2006-03-08 15:01:51.000000000 -0500
@@ -92,6 +92,13 @@
 I'll look into whether that's a bug.
 
 Mono.Data.SqliteClient with Sqlite2 uses ANSI encoding by default,
 which may not be good for F-Spot.  F-Spot should either give
 "encoding=UTF-8" in the connection string (that's new), or else use
 Sqlite3 ("version=3" in the connection string), which now uses Unicode.
+
+------- Additional Comments From tauberer at for.net  2006-03-08 15:01 -------
+And to correct myself, since Mono's Marshal.PtrToStringAnsi uses UTF-8
+rather than actually ANSI, Sqite2 is actually using UTF-8 encoding by
+default, but apparently a buggy unmanaged implementation of it. 
+Overriding with encoding=UTF-8 in the conn. string, which forces a
+managed implementation, gets rid of the problem.