odbc
odbc copied to clipboard
r-dbi
Connect to ODBC databases (using the DBI interface)
Right now we check for interrupts on the R side, but don't attempt to do anything to signal to the database that an interrupt occurred. Either calling `SQLCancel()` on the...
### Issue Description and Expected Result When the database's encoding is GBK, the client's encoding is UTF-8 and the SQL contains non-ASCII letters, the error message becomes garbage letters. The...
### Issue Description and Expected Result When the SQL contains non-ASCII strings as the field names, the returned **column names** of the data.frame is not encoded as UTF-8. ### Database...
I notice that in `R/db.R`, there are "custom" `sqlCreateTable` methods defined for RDBMSs that don't use the typical `CREATE TABLE` syntax (I think all of these so far are for...
We’re having a hard time reading the catalog for our Hive instance. It’s possible that the Hive metadata are messed up, but the fact I can query data would suggest...
### Issue Description and Expected Result `odbcListObjects()` doesn't return objects in the specified DB. Instead, it returns a list of all DBs in the connection, with the type of `catalog`:...
For teradata connection, when I try to create a sql query through sqlCreateTable, the output result is incorrect. Notice parameter `temporary` does not work too. ``` r # Packages require(reprex)...
### EDIT: found the cause with R gdb the segfault appears in: ``` Thread 1 "R" received signal SIGSEGV, Segmentation fault. 0x00007ffff753e930 in __lll_unlock_elision () from /lib64/libpthread.so.0 ``` googling the...
### Issue Description and Expected Result Occasionally connecting to my Teradata database fails: ```r # Fails ch
### Issue Description and Expected Result This is the same issue as #208 but for Oracle. Milliseconds are lost when inserted. The same code works with the ROracle package. ###...
