odbc_utf8_errors.rb

require 'odbc_utf8'

con = ODBC.connect 'vm2008', 'rails', ''

h = con.run "SELECT N'v' AS N'n'"
v = h.fetch.first   # => ODBC::Error: HY003 (0) [unixODBC][FreeTDS][SQL Server]Program type out of range
v.encoding          # => 
h.drop

sth_runprc = con.run "EXEC sp_helpconstraint 'people', 'nomsg'"
sth_runprc.columns(true).map{|c|c.name}  # => ["constraint_type", "constraint_name", "delete_action", "update_action", "status_enabled", "status_for_replication", "constraint_keys"]
sth_runprc.fetch_all                     # => ODBC::Error: HY003 (0) [unixODBC][FreeTDS][SQL Server]Program type out of range
sth_runprc.more_results                  # => 
sth_runprc.drop

sth_runsel = con.run "SELECT N'v' AS N'n'"
sth_runsel.columns(true).map{|c|c.name}              # => ["n"]
sth_runsel.columns(true).map{|c|c.name}[0].encoding  # => #<Encoding:UTF-8>
sth_runsel.fetch_all                                 # => ODBC::Error: HY003 (0) [unixODBC][FreeTDS][SQL Server]Program type out of range
sth_runsel.more_results                              # => 
sth_runsel.drop