From: Phillip Hutchings <sitharus@...>
Date: 2006-07-12T14:37:42+09:00
Subject: Re: Problem with adding a new record into MySQL DB

On 7/12/06, hongseok.yoon@gmail.com <hongseok.yoon@gmail.com> wrote:
> MySQL DB's character-set is UTF8 and RoR(Ruby on Rails)'s database.yml
> has a line 'encoding: utf8'.
> If I add a new record using RoR's new action via Web Browser, Korean is
> stored without problem.
> If I set fiels explicitly like 'MyActionRecord['fieldname'] = '<some
> Korean letters>', and invoke save method... yes, it works, but Korean
> is not saved correctly. English was okay with same code.

Firstly you want the rails list at
http://lists.rubyonrails.org/mailman/listinfo/rails

Secondly chances are you're not sending your web pages with the
content-type set correctly. Use something like LiveHTTPHeaders for
Firefox (don't have a URL I'm sorry) and see if you get a line like
this:
Content-Type: text/html; charset=utf8

you're sending UTF8 encoded pages, if not then you need to send it.
I'm not sure on how to do this in Rails, see the Rails list.
-- 
Phillip Hutchings
http://www.sitharus.com/