My SQL query has some chinese characters which are getting messed up.
The SQL server uses gb2312(chinese) encoding and so in my Ruby script I
use Iconv to convert from UTF-8 to gb2312. The conversion seems to work
fine, I have tried dumping the output to a text file and it all looks
great, but when it’s sent to the SQL server the chinese character get
messed up(which I got to know after looking at the trace log). I’m using
the DBI module to connect to the SQL server and “execute” function to
send the query. Can anyone please suggest a fix ?