You should also make sure that the browser is submitting the information as UTF8. If I recall, it's sufficient to declare the page with the form in it as utf8, but you might want to double-check that.
Search and replace is going to be tough unless there's an existing script around for doing that. One thing you could do is try writing a script in Java (or Ruby) that reads a known bad row from the database and converts it various ways and prints it out until you know exactly what conversion you're going to need. Programmatically detecting the messed-up strings seems like it would be more difficult, though, unless there are some clear constraints on what those strings should contain (i.e., something you can run a regex on), which might be the case if it's, say, a validated form field. Jun-Dai On 4/30/07, Ben Weiner <[EMAIL PROTECTED]> wrote: > > > Sure your browser is using the right encoding? If not, try setting the > > http Content-Type header. More reliable for me than a meta tag. > > Yes, the page seems to be set up fine. I've also tried installing the > BrowserFilters plugin, but that did not work either. > > I have a feeling it may be the case that when these characters were > originally put into the database, they were somehow entered incorrectly. > I seem to be able to enter the correct characters--i.e., curly > quotes--myself and they save and display fine. Is there any way to do > some sort of search and replace on these guys? > > Thanks for the help. > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Railsi18n-discussion mailing list > Railsi18n-discussion@rubyforge.org > http://rubyforge.org/mailman/listinfo/railsi18n-discussion > _______________________________________________ Railsi18n-discussion mailing list Railsi18n-discussion@rubyforge.org http://rubyforge.org/mailman/listinfo/railsi18n-discussion