Changeset 22337 for main/trunk/greenstone2

Timestamp:

2010-07-01T11:43:13+12:00 (14 years ago)

Author:

mdewsnip

Message:

Added calls to to_utf8() for key and data in setkeydata(), to get the encoding right for the SQLite database.

File:

• main/trunk/greenstone2/common-src/src/lib/sqlitedbclass.cpp (modified) (1 diff)

main/trunk/greenstone2/common-src/src/lib/sqlitedbclass.cpp

@@ -262 +262 @@
   if (!exists(key))
   {
-    text_t sql_cmd = "INSERT INTO data (key, value) VALUES ('" + sql_safe(key) + "', '" + sql_safe(data) + "')";
+    text_t sql_cmd = "INSERT INTO data (key, value) VALUES ('" + to_utf8(sql_safe(key)) + "', '" + to_utf8(sql_safe(data)) + "')";
     return sqlexec(sql_cmd);
   }
   else
   {
-    text_t sql_cmd = "UPDATE data SET value='" + sql_safe(data) + "' WHERE key='" + sql_safe(key) + "'";
+    text_t sql_cmd = "UPDATE data SET value='" + to_utf8(sql_safe(data)) + "' WHERE key='" + to_utf8(sql_safe(key)) + "'";
     return sqlexec(sql_cmd);
   }