Problem with adding a new record into MySQL DB

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.

How can I convert Korean letters to UTF8 characters? I did many tries
and finally I'm here.

irb(main):001:0> "한글" <-- I can't sure you guys can see this
letter. They are just two Korean letters.
=> "\307\321\261\333" <--- What the hell.....T^T
irb(main):002:0> "aaa" <--- English, of course.
=> "aaa" <--- No problem. - -

Please help...

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.

···

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.

--
Phillip Hutchings
http://www.sitharus.com/

I can see it. :slight_smile:
Secondly, the output from irb is the #inspect string. Try doing
puts "한글"

and see if that gives you what you expect. (Works good for me)

···

On Jul 12, 2006, at 12:50 AM, 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.

How can I convert Korean letters to UTF8 characters? I did many tries
and finally I'm here.

irb(main):001:0> "한글" <-- I can't sure you guys can see this
letter. They are just two Korean letters.
=> "\307\321\261\333" <--- What the hell.....T^T
irb(main):002:0> "aaa" <--- English, of course.
=> "aaa" <--- No problem. - -

Please help...