-
Notifications
You must be signed in to change notification settings - Fork 2.3k
Description
From Josh Koch via Applied Informatics Support (Ticket #1898):
I have made a few meta column additions to the Data ODBC and SQLite libraries (see attached diff files for poco release 1.5.2).
The additional ODBC type was added for PostgreSQL type "char" which seems to come back as integer value "-8" in Data/ODBC/src/ODBCMetaColumn.cpp:
line 110: case -8:// PostgreSQL CHAR (with size specified - psqlODBC)
I am using the following versions of PostgreSQL and psqlODBC driver on Windows 7.
PostgreSQL 9.2
psqlODBC driver
http://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_02_0100.zip
http://ftp.postgresql.org/pub/odbc/versions/msi/psqlodbc_09_02_0100-x64.zip
Also for Data SQLite, 3 additional types were added relating to MS SQL Server integer types TINYINT, SMALLINT, and BIGINT.
http://technet.microsoft.com/en-us/library/ms187745.aspx
We use various MS SQL Server to SQLite converter utilities which keep these types defined in the resulting SQLite database file.
I am not sure if these types should live in Data/SQLite/src/Utility.cpp, but would be really useful to us if they did.
Patches:
https://appinf.zendesk.com/attachments/token/kcyvgve0tnexj87/?name=Data.ODBC.src.ODBCMetaColumn.cpp.diff
https://appinf.zendesk.com/attachments/token/j7nqzxrsa7zjmej/?name=Data.SQLite.src.Utility.cpp.diff