Dataset issue #537

Closed
marcogallo opened this Issue Aug 17, 2012 · 1 comment

Comments

Projects
None yet
2 participants

Good morning,

i have a issue when reading a dataset from MSSQL server 2000 db.
i'm connection using this way:
Sequel.connect(:adapter=>'odbc',:driver=>'SQL Server',:server=>'myserver',:uid=>'myuser',:pwd=>'mypass',:database=>'mydb',:db_type=>'mssql', :encoding => 'utf8', :charset => 'utf8')

this is the dataset's row result of my query:
{:myField=>"W030725\x00\x00"}

the problem is that myField in db is an nvarchar(8) and in my result is truncated on last char (returned 7 chars instead of 8 chars)

Thanks in advance,
Marco.

Owner

jeremyevans commented Aug 17, 2012

Looking at your results, it appears that myField has 9 chars instead of 8, if you include the two \x00 chars. I believe this is an ruby-odbc issue, as I've seen similar issues on ruby-odbc with \x00 values. You should try using the tinytds adapter instead of the odbc adapter, it will probably work better.

Unless you can show the underlying ruby-odbc connection object can return correct results if used directly, I'm going to assume this is a ruby-odbc issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment