Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
comp.lang.ruby
ruby chinese character encoding problem with SQL
bob
6/14/2007 1:46:00 AM
Hi,
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 ?
Thanks,
Bob
--
Posted via
http://www.ruby-...
.
1 Answer
Axel Etzold
6/14/2007 7:25:00 AM
0
Dear Bob,
maybe you can use Mysql.escape (see the "Including Special Characters in Statement Strings" of
http://www.kitebird.com/articles/ruby-...
to produce proper output.
I don't know any Chinese myself, but I had a similar problem with
European accents in web page addresses recently. The most elegant
solution was to use CGI.escape(string), so maybe something similar
will work for you using MySql.
Best regards,
Axel
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN:
http://www.gmx.net/de/go/s...
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
ruby chinese character encoding problem with SQL
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password