Skip to content

varchar(max) column type support

Compare
Choose a tag to compare
@zozlak zozlak released this 20 Nov 19:43
· 31 commits to master since this release

Added support for column types reporting 0 as its length (most notably Ms SQL Server's "varchar(max)" column type).

  • When passing data from R into a database, data of any size are supported (the available memory for ODBC buffers is the only limit).
  • When reading data from database into R a default RODBC's buffer length of 255 characters is used to assure compatibility with RODBC (RODBCext relies on RODBC functions on data retrieval).
    This means strings of type "varchar(max)" will be truncated to 255 charactes.