ruby on rails - heroku postgres - encoding

Question

I have a weird encoding problem or I do it simple the wrong way. Maybe someone have an idea what happens. Info: I'm new to ruby on rails!

I have an array of landscape names and they have special characters like 'äüöéèà...'. In my form I want the user to choose multiple items of these landscapes. So I started with an select_tag with all landscape names:

<%= select_tag 'model[landscapes][]', options_for_select(AVAILABLE_LANDSCAPES, @landscapes_selected), { :multiple => true, :size =>5, :id => "model_landscapes" } %>

In my model I save these names in the database and all works fine. I allready have a big database with these special characters in the landscape string. Existing landscape entries are given as 'ländscape1, lândscape2, blalilü'. I don't have problems with saving or getting data from the databse. On my local machine with a mysql database this works fine! But when I run my application on heroku I have an encoding problem. When I save a string with an char like 'â', it it saved with '\xC3\xA2'.

Never used heroku. But what are your server's and client's encodings from postgres? You can run these commands "show server_encoding; show client_encoding;" — chifung7
– chifung7, Commented Aug 26, 2012 at 4:46
Another thing to check: make sure you have this line '# encoding: utf-8' at the top of each file which has special characters hardcoded. — chifung7
– chifung7, Commented Aug 26, 2012 at 4:55
I tried to set encoding in different places! But nothing changed. To save 'äüöé...' in other fields in the heroku database is not the problem. Only when I used the select_tag I got this weird problem. My options look like <option value="Tèèst">Tèèst</option>. Maybe there is a problem with special characters in the value attribute of my option tag?? — Simon Franzen
– Simon Franzen, Commented Aug 26, 2012 at 10:47

Simon Franzen · Accepted Answer · 2012-08-26 16:09:05Z

1

I don't know why this problems only appears when I running my app on heroku!

But, this works for me:

My mistake was that I saved the selected landscapes as a string in my db!

serialize :landscapes

saves und loads my landscapes as an array and then I have no encoding problems!!!

answered Aug 26, 2012 at 16:09

Simon Franzen

2,72727 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

ruby on rails - heroku postgres - encoding

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