… then do charset conversion: UPDATE table SET column=CONVERT(CONVERT(CONVERT(column USING binary) USING utf8) USING cp1251) WHERE id=123; This can be further… column=CONVERT(CONVERT(column USING binary) USING utf8) WHERE id=123; The same trick could be applied to fix notorious KOI8-R vs CP1251…
Percona's MySQL & InnoDB performance and scalability blog
Percona Webinars
- June 26, 2013 - Percona XtraDB Cluster Operations
- July 17, 2013 - 5 Proactive Measures to Minimize MySQL Downtime
- July 24, 2013 - Advanced MySQL Query Tuning
- July 31, 2013 - Percona Server 5.6: Enterprise Grade MySQL
Percona MySQL Training
- Moving to MySQL 5.6 - Utrecht, Netherlands on Monday, 01 July 2013
- London, United Kingdom on Monday, 15 July 2013
- Moving to MySQL 5.6 - Orlando, FL on Monday, 15 July 2013
- Moving to MySQL 5.6 - Salt Lake City, UT on Thursday, 18 July 2013
- Boston, Massachusetts, USA on Monday, 22 July 2013
Percona Careers
- Administrative Aide [Uruguay]
- Consultant: Linux and Web System Administration
- Director of Open Source Development
- Perl Programmer [Americas timezone]
- MySQL Instructor [Any Location - US]
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.