incompatible character encodings: UTF-8 and ASCII-8BIT for Rails 3

sqlite3-ruby is not yet upgraded to support ruby 1.9. There is, however, a ticket by sqlite3-ruby's developer to get some updates to ActiveRecord's sqlite3 interface some time now: #3790 SQLite3 driver is changing, please update accordingly

I expect once this will be added to the recent versions of ActiveRecord, the new sqlite3 driver will follow soon with ruby 1.9 encoding support.

Hi,

I just tried with mysql, and got the same error.

I tried also with git's version of tenderlove's sqlite3-ruby, but I didn't manage to make it work (LoadError: no such file to load -- sqlite3/sqlite3_native).

mysql tagged, as sqlite3 the string as ASCII-8BUT, which is non-sense.

Isn't it rails3's fault to tag these String like that?
It doesn't look of a hazard both fail the same way ...

Thanks for your answer

MySQL driver is buggy as well; There is stuff like http://github.com/brianmario/mysql2, but, actually, this is not a Rails bug but a driver bug.

Latest Postgres binary gem (gem install pg) recognizes UTF-8 just fine.

Ok,

Thanks for the answers.

Regards,
B.D.

(I spoke of regression because rails 2.3.5 did worked with ruby 1.9 and these encodings)