Home » U++ Library support » U++ SQL » SQLITE: remove case sensitive of column type name.
SQLITE: remove case sensitive of column type name. [message #26665] |
Tue, 18 May 2010 17:25 |
|
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.
|
|
|
Goto Forum:
Current Time: Mon May 13 12:00:49 CEST 2024
Total time taken to generate the page: 0.02142 seconds
|