访问数量库时用
unicode -> utf8 or gb2312
unicode2utf8 从 http://yuweijun.blogspot.com/2008/12/rubyunicodeutf8.html 得到
DBI.connect(ODBC_NAME,ODBC_USER, ODBC_PWD) do |db|
db.do('set textsize 9999') # 如果没有这句会抛错
db.select_all("select * from
end
unicode -> utf8 or gb2312
require 'iconv'
require 'cgi'
class Iconv
def Iconv.unicode2utf8(unicode_string)
unicode_string.gsub(/\\u\w{4}/) do |s|
str = s.sub(/\\u/, "").hex.to_s(2)
if str.length < 8
CGI.unescape(str.to_i(2).to_s(16).insert(0, "%"))
else
arr = str.reverse.scan(/\w{0,6}/).reverse.select{|a| a != ""}.map{|b| b.reverse}
# ["100", "111000", "000000"]
hex = lambda do |s|
(arr.first == s ? "1" * arr.length + "0" * (8 - arr.length - s.length) + s : "10" + s).to_i(2).to_s(16).insert(0, "%")
end
CGI.unescape(arr.map(&hex).join)
end
end
end
def Iconv.unicode2gb2312(unicode_string)
u8_text = Iconv.unicode2utf8(unicode_string)
Iconv.iconv("UTF-8//IGNORE","GB2312//IGNORE",u8_text)
end
end
unicode2utf8 从 http://yuweijun.blogspot.com/2008/12/rubyunicodeutf8.html 得到