Jim Hester
Jim Hester
It is possible we should add a `dbListObjects()` method that includes the schemas (with `is_prefix == TRUE`), but `odbcListObjects()` is intended to produce a different type of result in this...
@shrektan any thought on @detule's last comment above? I have to do a odbc release to fix a compilation warning for CRAN, it would be nice to get this in...
The numbers are ODBC SQL data type codes https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/sql-data-types They are defined in [sql.h](https://github.com/Microsoft/ODBC-Specification/blob/master/Windows/inc/sql.h#L198-L225). I agree it would be nicer to have a name, but it is not entirely trivial...
I agree, I am just not positive that `timestamp with time zone` is portable across all databases.
You would have to define a `odbcListObjects` method for SQL Server that queried the synonyms and included them in the results I guess.
Hmm, I am not sure what we can do about this, if it takes a bit for the serverless server to start up after the first connection attempt, and that...
The `encoding` parameter needs to be set to the database encoding. It looks like you can query it using [`nzsql -c "show nz_encoding"`](http://www-01.ibm.com/support/docview.wss?uid=swg21567286).
What are the values returned for this query if you use nzsql directly? This is likely due to a mismatch in the unicode width between the driver and the database....
Did you try using `UnicodeTranslationOption = utf16`?