From: Ben Gribaudo <bgribaudo@...>
Date: 2006-01-12T01:58:05+09:00
Subject: Re: ruby-odbc -- Strange Chaning of Special Character in Result Set

Hi Lou,

Thanks for your reply.

> I recommend sending your output to a file and doing something similar to
> what I've done to see exactly what's being sent back from odbc instead
> of relying on a (possibly lying) terminal. It would also have been helpful to
> know which database [and version] you used.

I'm not concerned about if/how the terminal outputs the character--that
output was for illustration only. The "Char Code" line is the one of
interest. In my original script, shouldn't the terminal output this
number correctly?

Running your script and looking at the output file still shows a char
code of 63 for select char(150) and 150 for select ascii(char(150)).
:-(

I'm using MS Sql Server 7.0, FreeTDS and Ruby-ODBC.

> I didn't get any warnings when compiling ruby-odbc, but I was using gcc 34.4.

Christian (author of ruby-odbc) communicated with me about this and
provided a solution to the signedness difference error. Thank you,
Christian!

Ben