U++ forum: Welcome to the forum

SQLITE: remove case sensitive of column type name. [message #26665]

Tue, 18 May 2010 17:25

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

Hello all,

I propose to remove case sensitive of column type name.
I prepared a little patch for this:

Index: uppsrc/plugin/sqlite3/Sqlite3upp.cpp
===================================================================
--- uppsrc/plugin/sqlite3/Sqlite3upp.cpp	(revision 2404)
+++ uppsrc/plugin/sqlite3/Sqlite3upp.cpp	(working copy)
@@ -245,7 +245,8 @@
 	}
 
 	ASSERT(got_row_data);
-	String coltype = sqlite3_column_decltype(current_stmt,i);
+	// Remove case sensitive
+	String coltype = ToLower(sqlite3_column_decltype(current_stmt,i));
 	switch (sqlite3_column_type(current_stmt,i)) {
 		case SQLITE_INTEGER:
 			f = sqlite3_column_int64(current_stmt,i);

It is useful when I create a table
"CREATE TABLE Tab1(col1 DATETIME)".
When i execute a select statement, the conversion in Time is not correct.

Attachment: sqlite_remove_case_sensitive.patch
(Size: 0.54KB, Downloaded 244 times)

Report message to a moderator