Rails Json response encoding

Question

I've a rails controller that respond_to JSON with a wrong encoding. The site is correctly setup with UTF-8 encoding and the database as well. The text in my db is well formatted, but in the JSON response, all special characters are set to \ufffd. How can I solve the problem?

How are you getting data out of the database? Does it look OK before you JSON-encode it? Have you set encoding: utf8 in your database.yml? — bobince
– bobince, Commented Oct 30, 2010 at 20:57
yes. the database is utf8, the encoding:utf8 is correct, the string are correctly stored in the db (i double checked them with phpmyadmin). the problem is the way rails encode them with to_json method. — pasine
– pasine, Commented Oct 31, 2010 at 13:39

Lamp · Accepted Answer · 2010-11-01 20:45:50Z

5

+50

Everyone running on Ruby 1.9.x and using MySQL, should use the mysql2 gem. It forces the use of UTF-8 and converts to/from UTF-8 automatically when needed.

answered Nov 1, 2010 at 20:45

Lamp

1,0841 gold badge14 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mikabytes Over a year ago

This did not work for me. I'm running Sqlite and characters are written/read from database correctly, however upon using the to_json method all special characters (such as 'åäöячщ') turns into \ufffd

Collectives™ on Stack Overflow

Rails Json response encoding

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related