我在windows下用netbeans编写ruby程序,想往数据库中插入一些数据。代码如下
require 'rubygems'
gem 'dbd-mysql'
require 'mysql'
require 'iconv'
begin
# connect to the MySQL server
dbh = Mysql.real_connect("localhost", "root", "root","enroll", 3306) #连接数据库本机:用户名:root 密码:sa 数据库:makedish 端口$1�706
# get server version string and display it
@stu_name="测试"
puts @stu_name
sql2="insert into candidate (candidate_name,id_card_no,candidate_no,state,has_submitted,the_year) VALUES ('"+@stu_name.to_s+"','123','123','A','Y','2011')"
puts sql2
dbh.query(sql2)
res = dbh.query("select * from candidate")
res.each do |ha|
p ha
end
rescue Mysql::Error => e
puts "An error occurred"
puts "Error code: #{e}"
puts "Error message: #{e.errstr}"
ensure
# disconnect from server
dbh.close if dbh
end
采用HeidiSQL查看Mysql数据,发现写进去的中文全是乱码
不知道有什么好的解决办法吗