[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 hackel at walkingfish.com.

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

--- shadow/77711	2006-03-05 19:34:43.000000000 -0500
+++ shadow/77711.tmp.7941	2006-03-05 19:53:37.000000000 -0500
@@ -1,14 +1,14 @@
 Bug#: 77711
 Product: Mono: Class Libraries
 Version: 1.1
-OS: 
+OS: unknown
 OS Details: Ubuntu/dapper
 Status: NEW   
 Resolution: 
-Severity: 
+Severity: Unknown
 Priority: Major
 Component: Sys.Data.SqlClient
 AssignedTo: tsenganal at novell.com                            
 ReportedBy: hackel at walkingfish.com               
 QAContact: mono-bugs at ximian.com
 TargetMilestone: ---
@@ -57,6 +57,25 @@
 
 I would consider this to be a very critical issue.  I've just run into it
 as an English speaker myself, and so I can't imagine how frustrating it
 must be for a non-English speaker!
 
 Related f-spot bug: http://bugzilla.gnome.org/show_bug.cgi?id=333550
+
+------- Additional Comments From hackel at walkingfish.com  2006-03-05 19:53 -------
+Mono.Data.SqliteClient.dll contains references to both sqlite and
+sqlite3 functions, so I assume it can use either library, and is
+defaulting to sqlite2.
+
+If I remove libsqlite0 (leaving only libsqlite3-0 installed) and
+delete my old db, the new database is created in sqlite3 format and
+this bug goes away.
+
+I therefore don't know if this bug belongs to f-spot, mono or the
+Ubuntu packages in determining whether to use sqlite 2 or 3, but it
+seems like it should default to the highest version available if it
+can use both.
+
+Either way, this bug is still valid for the sqlite2 case--there is
+still a bug in retrieving the non-ascii values since they are
+obviously stored correctly in the DB as the native sqlite tool can
+retrieve them but mono can't.