On Saturday, March 24, 2018 at 3:56:24 AM UTC-7, Satyanarayana Gandham wrote: > > Hi, > > I am trying to migrate from using mysql gem to mysql2 gem because of some > DB transaction related issues. But, when I retrieve data from tables, I am > getting the data as "St. Michael’s Hopsital" instead of "St. Michael’s > Hopsital". When I am using mysql gem, I used force_encoding plugin with > 'UTF-8'. In DB, it is stored as "St. Michael’s Hopsital". > > Can you guys please help me solving this issue? >
Since you didn't mention how either the mysql or mysql2 configurations are setup, it's hard to guess what the problem might be. You may have to put together a reproducible example. You could try using the :encoding => 'utf8' option when creating the Sequel::Database object if you are not already doing that. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
