在Windows上使用sqlite3-ruby进行未初始化的常量编码

LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8

gem install sqlite3

require 'sqlite3'

# 设置编码
SQLite3::Database.class_eval do
  def execute2(sql, *bind_params)
    if sql.encoding != Encoding::UTF_8
      sql = sql.dup.force_encoding(Encoding::UTF_8)
    end
    bind_params.each do |bind_param|
      if bind_param.is_a?(String) && bind_param.encoding != Encoding::UTF_8
        bind_param = bind_param.dup.force_encoding(Encoding::UTF_8)
      end
    end
    execute(sql, bind_params)
  end
end

# 连接到数据库
db = SQLite3::Database.new('test.db')

# 执行SQL查询
db.execute2('SELECT * FROM users')