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’] = ‘’, 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…

On 7/12/06, [email protected] [email protected] 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’] = ‘’, 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.

On Jul 12, 2006, at 12:50 AM, [email protected] wrote:

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…

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)

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs