tiny_tds: 2.1.2
Version: freetds v1.1.20
freetds.conf directory: /etc
MS db-lib source compatibility: yes
Sybase binary compatibility: yes
Thread safety: yes
iconv library: yes
TDS version: auto
iODBC: no
unixodbc: yes
SSPI "trusted" logins: no
Kerberos: yes
OpenSSL: no
GnuTLS: yes
MARS: yes
FreeTDS Version
v1.1.20
Description
After updating tiny_tds to 2.1.2 I've noticed some weirdness with the sql_variant data type. I have an extended property with a value of true that is being converted into 1702195828. This doesn't seem to happen in v1.0.5 or in Azure Data Studio.
Environment
Operating System
AWS Lambda Ruby Docker container:
lambci/lambda:build-ruby2.7
TinyTDS Version and Information
FreeTDS Version
Description
After updating
tiny_tds
to2.1.2
I've noticed some weirdness with thesql_variant
data type. I have an extended property with a value oftrue
that is being converted into1702195828
. This doesn't seem to happen inv1.0.5
or in Azure Data Studio.I believe it might be related to this logic: https://github.com/rails-sqlserver/tiny_tds/blob/master/ext/tiny_tds/result.c#L329, but I'm not completely positive. I don't know if I have a solution, but I did want to raise the issue.
I am able to work around this issue by casting the column as a
VARCHAR(2000)
. Here is a little example: