Mar 10
3

Migrating MySQL latin1 to utf8 – Character Set Options

1 Comment

This entry is part 2 of 4 in the series Migrat­ing MySQL latin1 to utf8

Migrat­ing MySQL latin1 to utf8

• Migrat­ing MySQL latin1 to utf8 – Preparation
• Migrat­ing MySQL latin1 to utf8 – Char­ac­ter Set Options
• Migrat­ing MySQL latin1 to utf8 – The process
• Migrat­ing MySQL latin1 to utf8 – In House Version

Con­tin­u­ing on from prepa­ra­tion in our MySQL latin1 to utf8 migra­tion let us first under­stand where MySQL uses char­ac­ter sets. MySQL defines the char­ac­ter set at 4 dif­fer­ent lev­els for the struc­ture of data.

via Migrat­ing MySQL latin1 to utf8 – Char­ac­ter Set Options

More From HackIX

• Zend Frame­work 1 and Doc­trine 2 Integration
• Migrat­ing MySQL latin1 to utf8 – Preparation
• Migrat­ing MySQL latin1 to utf8 – The process

Ask HackIX To Rec­om­mend Your Posts

Series Nav­i­ga­tion

Migrat­ing MySQL latin1 to utf8 – Prepa­ra­tionMigrat­ing MySQL latin1 to utf8 – The process

Tags: Migration, MySQL, UTF-8

This entry was posted on 3 March, 2010 at 23:02. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Posted in Databases Development MySQL System Administration by Danny Froberg 1 Comment

1 Response to "Migrating MySQL latin1 to utf8 – Character Set Options"

• Migrating MySQL latin1 to utf8 – The process -HackIX says:

  8 March, 2010 at 15:24

  Reply

  […] and Poedit (3) Other posts belong­ing to this seriesMi­grat­ing MySQL latin1 to utf8 – Prepa­ra­tion­Mi­grat­ing MySQL latin1 to utf8 – Char­ac­ter Set Option­s­Mi­grat­ing MySQL latin1 to utf8 – The […]

Leave a Comment

Click here to cancel reply.

Name (required)

Email (will not be published) (required)

Website URL

CAPTCHA Code *

• 
  Select LanguageAfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBelarusianBulgarianCatalanChinese (Simplified)Chinese (Traditional)CroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishThaiTurkishUkrainianUrduVietnameseWelshYiddish

• Welcome

  

• 	United States	4250 (10 %)	7031 (9 %)
  	Germany	3618 (8 %)	6431 (8 %)
  	France	3358 (8 %)	6076 (8 %)
  	Poland	2453 (6 %)	4628 (6 %)
  	India	2150 (5 %)	3674 (5 %)
  	Sweden	1945 (5 %)	6594 (8 %)
  	Brazil	1884 (4 %)	3187 (4 %)
  	United Kingdom	1743 (4 %)	3128 (4 %)
  	Netherlands	1566 (4 %)	2859 (4 %)
  	Canada	1210 (3 %)	2323 (3 %)

  Total Countries:	149
  Total Visits:	42799
  Total Pageviews:	80146

• Tags

  AIR Ajax Android Bootstrap Cloud CSS Doctrine Documentation Flash Flex JQuery JSON Migration Models MySQL PHP phpUnit plugin poedit REST Security sqllite Tool Tutorial UTF-8 webservice Windows xml Zend ZendAMF Zend Framework Zend Studio Zend_Acl Zend_Amf_Server Zend_Auth Zend_Db Zend_Form Zend_Form_Decorators Zend_Locale Zend_Registry Zend_Session Zend_Test Zend_Tool Zend_Translate Zend_View

• Recent Comments

  • Danny Froberg on Configuring Poedit for Zend Framework Projects
  • Stamrecht BV on Configuring Poedit for Zend Framework Projects
  • Danny Froberg on Zend_Acl & Zend_Navigation
  • Danny Froberg on Configuring Poedit for Zend Framework Projects
  • thero on Zend_Acl & Zend_Navigation

• Recent Posts

  • ClamAV as a Validation Filter in Zend Framework
  • Hackix #JS #sopastrike #SOPAblackout #sopa
  • Zend Server 5.6 is out
  • How To Take Screenshot on the iPad2
  • Connecting to PHPCloud.com through Zend Studio 9
  • How to create custom MouseEvent.CLICK event in AS3 (pass parameters to function)?
  • Creating a Windows AIR Native Extension with Eclipse
  • Drag-and-Drop in Flex 4
  • Splash screen with FXG in Mobile applications with Flash Builder for PHP
  • Flex wrappers for MadComponents
  • MadComponents AMF Service Test Drive for Mobile
  • Zend AMF Authentication & Authorization
  • Authentication using Zend_Amf
  • SkinnableTextBase focusManager runtime error popup
  • Flex mobile in the browser
  • File uploads with Adobe Flex and Zend AMF
  • Shine MP3 Encoder on Alchemy
  • WAVWriter.as
  • Flex Builder 4.5.x Test Drive for Mobile Tutorials
  • Data paging with Flex and PHP using Flash Builder 4.5.x
  • Zend_Config_Ini and a string
  • Encrypt session data in PHP
  • XML to JSON in PHP
  • Create daemons in PHP
  • A Zend Framwork compound form element for dates
  • Usage of the Conditional Ternary operator to reduce brace and newline waste when processing optional method parameters
  • Zend Studio & Eclipse Code Templates and Snippets for PHP
  • ExtJs, ExtDesigner and Zend Framework
  • Unit Testing Doctrine 2 Entities
  • About using UTF-8 fields in MySQL
  • Handling exceptions in a Front Controller plugin – Rob Allen’s DevNotes
  • Local config files and Zend_Application
  • Unit Testing Action Helpers
  • Zend Framework 1.11.0 FINAL Released
  • Zend SimpleCloud and Azure
  • Zend Framework 1.11.0BETA1 Released
  • Using Action Helpers To Implement Re-Usable Widgets
  • High Scalability — More Troubles with Caching
  • You want to do WHAT with PHP? Chapter 10
  • You want to do WHAT with PHP? Chapter 9
  • Zend_Log with multiple writers
  • Zend_Server Class
  • Finding syntax errors in your PHP Project files
  • Search each class for function names that match except for the underscore prefix
  • Testing Zend Framework controllers in isolation
  • Zend Framework 2.0 (2.0.0dev1)
  • Autocomplete Control with ZendX_JQuery
  • Working with ZendX_JQuery
  • A contents index for Zend Framework manual pages
  • Tutorial: Getting Started with Zend_Auth

• Partners

  EasyT­ele­com