sqlite-jdbc icon indicating copy to clipboard operation
sqlite-jdbc copied to clipboard
verified publisher icon xerial

TIMESTAMP not detected for valueType SQLITE_TEXT with typeName "TIMESTAMP"

Open mukoki opened this issue 5 years ago • 0 comments

Timestamp detection has been added in #114 , but only for SQLITE_INTEGER, not for SQLITE_TEXT. The problem can be observed if one export a typestamp column from QGIS. It is exported in the TEXT format with the type TIMESTAMP, but JDBC3ResultSet.getColumnType() returns VARCHAR sql data type so that importer has few chance to guess it contains TIMESTAMPs.

mukoki avatar Aug 22 '20 18:08 mukoki