I've set all collation and characters sets to UTF8 in PHP and MySQL. There is no problem. But as seen on http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html, standard utf8_general_ci
collation uses three bytes for storing characters. That should be enough to store all BMP characters. But I've still found no hint, if all korean and japanese characters are included in BMP or if there are characters that needs four bytes to be stored. I simply want to know, if utf8_general_ci
and utf8_bin
are really enough to store all korean/japanese characters, or if I have to use utf8mb4_general_ci
and utf8mb4_bin
?
Does MySQL UTF8 collation fit japanese and korean characters?
2.2k Views Asked by rabudde At
1
There are 1 best solutions below
Related Questions in MYSQL
- How to correctly work on a GreaseMonkey userscript using git?
- continuous integration - build separated projects or build all in one?
- MS-Access form: Is it possible to create a Gantt chart and dynamic timeline?
- MS Project - Adding multiples of the same resources to multiple concurrent tasks
- Cannot add embedded binaries (other projects) to project dependencies in XCode
- IntelliJ IDEA not showing my module/project
- How to arrange / manage methods of different functionality in a big project
- Team based project management software using .NET
- PM getting a feel for the time a Drupal site takes
- V-Modell-XT: creating new project: "missing file V-Modell-XT.xml" (model files missing / installer is needed)
Related Questions in UNICODE
- How to correctly work on a GreaseMonkey userscript using git?
- continuous integration - build separated projects or build all in one?
- MS-Access form: Is it possible to create a Gantt chart and dynamic timeline?
- MS Project - Adding multiples of the same resources to multiple concurrent tasks
- Cannot add embedded binaries (other projects) to project dependencies in XCode
- IntelliJ IDEA not showing my module/project
- How to arrange / manage methods of different functionality in a big project
- Team based project management software using .NET
- PM getting a feel for the time a Drupal site takes
- V-Modell-XT: creating new project: "missing file V-Modell-XT.xml" (model files missing / installer is needed)
Related Questions in UTF-8
- How to correctly work on a GreaseMonkey userscript using git?
- continuous integration - build separated projects or build all in one?
- MS-Access form: Is it possible to create a Gantt chart and dynamic timeline?
- MS Project - Adding multiples of the same resources to multiple concurrent tasks
- Cannot add embedded binaries (other projects) to project dependencies in XCode
- IntelliJ IDEA not showing my module/project
- How to arrange / manage methods of different functionality in a big project
- Team based project management software using .NET
- PM getting a feel for the time a Drupal site takes
- V-Modell-XT: creating new project: "missing file V-Modell-XT.xml" (model files missing / installer is needed)
Related Questions in UTF8MB4
- How to correctly work on a GreaseMonkey userscript using git?
- continuous integration - build separated projects or build all in one?
- MS-Access form: Is it possible to create a Gantt chart and dynamic timeline?
- MS Project - Adding multiples of the same resources to multiple concurrent tasks
- Cannot add embedded binaries (other projects) to project dependencies in XCode
- IntelliJ IDEA not showing my module/project
- How to arrange / manage methods of different functionality in a big project
- Team based project management software using .NET
- PM getting a feel for the time a Drupal site takes
- V-Modell-XT: creating new project: "missing file V-Modell-XT.xml" (model files missing / installer is needed)
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The most frequently used characters are in the BMP. The characters in higher planes are mostly rare and historic, but some of them may be in use in personal names for example. If you can use
utf8mb4
you probably should.