ruby-on-rails - rails : Error when trying to save a special character to database when using ActiveRecord and TinyTDS

Question

我正在尝试使用 ActiveRecord 将这个字符“É”作为字符串的一部分保存到我使用 TinyTDS 的 sql 服务器。知道我需要做什么来消除以下错误吗？

Exiting
/var/lib/gems/1.9.1/gems/activerecord-sqlserver-adapter-3.2.10/lib/active_record/connection_adapters/sqlserver/database_statements.rb:387:in `execute': TinyTds::Error: Error converting characters into server's character set. Some character(s) could not be converted

我想它出错的字符串如下:JEREMÉ

下面是我用来解析文件的代码...

csv = CSV.parse(csv_text, :headers=>false, encoding: "UTF-8")
csv.drop(2).each do |row|
    person = Person.new(:lastname => row[0], :firstname => row[1])
    playerstats.save
end

Answer 1

value = value.force_encoding('ISO-8859-1').encode('UTF-8')

这将使您的字符串数据库满意。