Microsoft quotes issue

hi group,

I have an annoying issue.

? appears in place of ".

This is caused due to pasting the info from the Microsoft word. Word uses curly quotes instead of simple quotes. Can you please help me to fix this issue. Since I'm new to Ruby, this looks like a big issue for me :slight_smile:

Thanks!

This is not a Ruby or a Rails issue. More than likely the quotes fall
at different code points in your database than in the code page
you've specified for your page. I worried this issue for a couple of
years on-and-off with a PHP site before concluding it had more to do
with the way MySQL handles multibyte characters than anything else.

You might take Postgres out for a spin or ... anyone else have ideas
about how iconv or something else could remove the question marks?

This is not a Ruby or a Rails issue. More than likely the quotes fall at different code points in your database than in the code page you've specified for your page. I worried this issue for a couple of years on-and-off with a PHP site before concluding it had more to do with the way MySQL handles multibyte characters than anything else.

You might take Postgres out for a spin or ... anyone else have ideas about how iconv or something else could remove the question marks?

Clean the input using tidy...

http://tidy.rubyforge.org/

-philip