change encoding,rails and mysql

Question

I did not mention encoding in my database.yml file.And now after parsing a site,a lot of data is saved with special characters.

Is there a way to change or set the encoding to utf-8 now?And what is the best way to do it,would really appreciate if you can explain it with little snippets of code.

Or do I need to do the parsing again.

Doing the parsing again with the correct encoding specified would probably be the easiest way. — Pekka
– Pekka, Commented Nov 4, 2011 at 8:30
ya but it would take hours again,so if there is another way i would really prefer that — Anidhya Ahuja
– Anidhya Ahuja, Commented Nov 4, 2011 at 8:33
You'll need to show how your characters are broken exactly — Pekka
– Pekka, Commented Nov 4, 2011 at 8:33

Nakul · Accepted Answer · 2011-11-04 08:33:38Z

1

No, it is not possible to do it without reconfiguring configurations and fixing existing data. Else, you will end up corrupting your db (some data in one encoding and some in another)

This should help:

answered Nov 4, 2011 at 8:33

Nakul

1,60011 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

change encoding,rails and mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related