Jump to Navigation
Home

Languages

  • English

Login

Search form

  • About us
  • Services
  • Tools
  • Resources
  • Download

Latin1

MariaDB and MySQL Character Set Conversion

Sat, 2019-08-17 21:50 — Shinguz

Table of Contents

  • Introduction
  • Character Sets
  • Steps to convert Character Set to utf8mb4
    • Analyzing the Server
    • Analyzing the Application and the Clients
    • Preparation of the Server Settings and the Application
    • Convert Tables to utf8mb4
    • Testing of new Character Set
  • MySQL Pump
  • MySQL Master/Slave Replication for Character Set conversion
  • MySQL Shell, mysqlsh Upgrade Checker Utility

Introduction

Recently we had a consulting engagement where we had to help the customer to migrate from latin1 Character Set to …

tags: 
character set
conversion
upgrade
latin1
utf8
utf8mb4
replication
mysqlsh
mysqlpump
  • Read more about MariaDB and MySQL Character Set Conversion
Subscribe to RSS - Latin1

  • About us

    • News
    • About FromDual
    • Contact
    • Partner
    • References
    • Newsletter
    • Press

  • Services

    • Consulting
    • Support
      • MySQL
      • DB Development
    • Remote-DBA
    • Training
      • Training Modules
      • Class Schedule
      • for Developer
      • for Administrators
      • Galera Cluster

  • Tools

    • Performance Monitor
    • Ops Center
    • MyEnv
    • SQL Formatter
    • Database Health Check
    • Performance Tuning Key
    • Consulting tools
    • MySQL Configuration

  • Resources

    • Blog
    • Forum
    • Presentations

  • Download

  • Recent content

Trademarks

RSS LinkedIn X / Twitter Facebook Flickr Bluesky YouTube Mastodon Matrix PeerTube Codeberg twitter

MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB®, the sea lion logo and MaxScale® are registered trademarks of MariaDB Corp. All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner.