Jim Hester

In this case it means I need to be able to reproduce it myself, but I cannot because I do not currently have access to a netezza db

The ODBC Specification seems to be that all SQLWCHAR data should be [little endian](https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/programming-guidelines?view=sql-server-2017) > SQLWCHAR data must be UTF-16LE (Little Endian). So this seems like a driver issue to...

It is most likely a Unicode character width mismatch between what R / odbc is expecting and what the snowflake driver is sending. I doubt I will have time to...

Any update on this @edgararuiz? the change is trivial, but IIRC you don't need explicit semicolons at the end of statements in the ODBC API, so it is a bit...

You would define a dbQuoteString for Hive connections, in https://github.com/r-dbi/odbc/blob/master/R/db.R e.g. ```r setMethod( "dbQuoteString", "Hive", function(conn, x, ...) { if (is(x, "SQL")) return(x) if (!is.character(x)) stop("x must be character or...

You would also likely need to define a `dbQuoteIdentifier` method as well

I don't know, but I notice you are using `AUTHENTICATIONPARAMETER=%s@@%s"` in your call to `RODBC` but not using it in your call to `odbc` perhaps that is causing the difference?

The cctz code is from https://github.com/google/cctz. It looks like possibly https://github.com/google/cctz/pull/112 would fix this in the upstream repo. We would have to update the vendored code in the odbc package...

I don't know why you would not be able to view `con`. I will not really be able to help with this unless I have access to Infomix, which I...

From https://www.connectionstrings.com/formating-rules-for-connection-strings/ > f a semicolon (;) is part of a value it must be delimited by quotation marks (") So you could try `PWD = "\"%={&$>#\""` in the above.