Patch merged-in http://dev.rubyonrails.org/changeset/7116
Thanks to bitsweat :) On Jun 22, 9:17 am, Matt Aimonetti <[EMAIL PROTECTED]> wrote: > Manfred, 'lazy' was indeed not the best word to describe the reason > behind this patch but thanks for your support. > > Here is an example of what could happen if you use utf-8 data without > the proper encoding set in your driver. > > This is what you should see, a drop down with 3 languages named in > their own > language.http://www.railsontherun.com/assets/2007/6/22/utf8db-encoding-html_th... > > This is what you get if you don't set the encoding to utf-8 in your > database.yml > file:http://www.railsontherun.com/assets/2007/6/22/utf8-db_no_encoding_utf... > > And just for fun, here is the same list with the html charset set as > iso8859-1http://www.railsontherun.com/assets/2007/6/22/utf8db-no_encoding-iso8... > > The above screenshots were taken using mysql. When using Postgresql > without defining the encoding for the db driver, the data is displayed > properly (in utf-8 as shown in screenshot #1). > > I added he encoding setting to the postgresql template because Manfred > asked for it and also because I think it's good to be consistent as > much as possible. > > -Matt > > On Jun 22, 6:49 am, Michael Glaesemann <[EMAIL PROTECTED]> wrote: > > > On Jun 22, 2007, at 0:42 , Manfred Stienstra wrote: > > > > Not many people know why and that you have to set the encoding in the > > > database driver. > > > AIUI, the server encoding and the client encoding (here defined by > > the driver), don't necessarily have to match. In cases where the > > client encoding doesn't match the server encoding, the server > > translates from the client encoding to the server encoding. For > > related PostgreSQL documentation, see > > >http://www.postgresql.org/docs/8.2/interactive/multibyte.html > > > I'd be surprised if other database servers don't have similar > > functionality. > > > I think a more likely problem is when the HTML charset and client > > encoding don't match. > > > Of course, if the default is UTF-8 for the HTML, it makes sense to > > use UTF-8 in the database client (driver) as well. > > > Michael Glaesemann > > grzm seespotcode net --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---
