Azure / Azure/azure-mysql

Database Charset Not Preserved

Open
#21 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
PHP
Stars
53
Forks
88
PR merge metrics
No merged PRs in 30d

Description

When running the script the database charset was not preserved. This will stop your emojis, or any special characters, from being transferred correctly. I recommend adding --default-character-set= in my case --default-character-set=utf8mb4 to both the mysqldump and mysql. Also for large databases I recommend removing the -v flag so every insert isn't printed to the console. I would also recommend not using Azure Cloud Shell as the timeout of 20 min is too short to successfully migrate a large database.

Contributor guide

No contributing guide indexed for this repository

Research direction

Locate the migration script and the mysqldump/mysql commands it runs. Verify how the character set and verbose output are passed, then confirm that a migration preserves emojis and special characters; treat the Azure Cloud Shell timeout note as an environment constraint.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, mysql
Domain
cloud, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
28/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.