Rails - Jun 2006 - 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?

-- 
seth at subimage interactive
http://www.subimage.com/sublog/
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060628/507efeaa/attachment.html

Anyone....anyone?

On 6/27/06, subimage interactive <subimage@gmail.com>
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.
>
> Quotes are turning into question marks, etc.
>
> Anyone have a fix / workaround for this?
>
> --
> seth at subimage interactive
> http://www.subimage.com/sublog/
>


-- 
seth at subimage interactive
http://www.subimage.com/sublog/
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060628/b6f296a1/attachment.html

On 28-jun-2006, at 20:00, subimage interactive wrote:
> Anyone....anyone?
>
> On 6/27/06, subimage interactive <subimage@gmail.com> 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?

On 6/28/06, carmen <_@whats-your.name> 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.
>
> 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..
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060628/7c7e7259/attachment.html

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?

On 6/28/06, Steve Longdo <steve.longdo@gmail.com>
wrote:
>
> 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?
>
>
> On 6/28/06, carmen <_@whats-your.name> 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.
> >
> > 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..
> > _______________________________________________
> > Rails mailing list
> > Rails@lists.rubyonrails.org
> > http://lists.rubyonrails.org/mailman/listinfo/rails
> >
>
>
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
>
>

-- 
seth at subimage interactive
http://www.subimage.com/sublog/
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060629/4dd81984/attachment.html