Funky character display in rails / mysql

I’m getting complaints from one of my customers that characters in their
text are getting mangled. This happens when they paste data into my
textboxes in rails from MS word in particluar.

Quotes are turning into question marks, etc.

Anyone have a fix / workaround for this?

Anyone…anyone?

On 28-jun-2006, at 20:00, subimage interactive wrote:

Anyone…anyone?

On 6/27/06, subimage interactive remov[email protected] wrote:
I’m getting complaints from one of my customers that characters in
their text are getting mangled. This happens when they paste data
into my textboxes in rails from MS word in particluar.

It’s a Unicode problem, probaby multilayered. Try to switch to UTF
for your site and database then ask your clients to paste these again.


Julian ‘Julik’ Tarkhanov
please send all personal mail to
me at julik.nl

I’m getting complaints from one of my customers that characters in their text are getting mangled. This happens when they paste data into my
textboxes in rails from MS word in particluar.

It’s a Unicode problem, probaby multilayered. Try to switch to UTF for your site and database then ask your clients to paste these again.

what is the preferred way to ‘switch to UTF’ right now? ive got a site
converted from drupal, the database hasnt been touched by ruby but it
definitely mangles it before displaying. lots of black diamonds with
question marks in them, and other weirdness…

Is there anyway to force string attributes to save as UTF in Ruby/Rails?

I had some foreign language characters on my blog and one of the Typo
migrations seems to have messed them up. The database has been set to
UTF
the whole time, do Rails migrations not honor that or is it just a
limitation of Ruby’s unicode (un)support?

I can’t believe nobody has run into this problem? So what’s the
‘official’
word on how to fix data already corrupted like this? What charset should
we
be using on MySQL?

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