I’ve found very few on the net in regards of Windows and the option
available in the ODBC Driver/ODBC Driver Manager.
So the following problem still remain unsolved:
irb> require ‘odbc’
irb> conn = ODBC::connect(‘giomai_db_dsn’, ‘sa’, ‘password’ )
irb> query = conn.prepare("select * from città where idcittà = 1)
ODBC::Error: 37000 (170) [Microsoft][ODBC SQL Server Driver][SQL
Server]Riga 1: sintassi non corretta in prossimitα di ‘à’.
from (irb):xx:in `execute’
This is from Commands Prompt that use
Tabella codici attiva: 850 ----------> CP850
that doesn’t include the ‘α’ character of the error message, and that is
the same both,
if toggle on or off the option ‘convert data characters’ in Driver
configuration from Windows ODBC driver manager.
Beside, in linux, I solved setting ‘character code = UTF8’ in
because the DB use CP1252, and this way it doesn’t influence the entire
In fact, in windows, it also results in error from rail execution:
( RadRails )
Exception occurred during reader method compilation.
Maybe IDCitt� is not a valid Ruby identifier?
syntax error, unexpected tSTRING_BEG, expecting ‘)’
def IDCitt�; missing_attribute(‘IDCitt�’, caller) unless
@attributes.has_key?(‘IDCitt�’); ([email protected][‘IDCitt�’]) && (v.to_i
rescue v ? 1 : 0); end
I don’t know where to investigate,
because linux also use ruby-odbc, I think!
But using Client ODBC in windows I have good result on the same table,
maybe because the client convert the characters code for the output
Can you help me?