mysql/php korean text collation issue

Job ID: 36709002

Budget: $10 – $30 USD

MySQL/PHP Korean Text Collation Issue

I am looking for a freelancer who can help me with a collation issue related to storing Korean text in my database. The current collation of the database is utf8_unicode_ci.

Skills and experience required:
- Strong knowledge of MySQL and PHP
- Familiarity with different collation options and their impact on storing Korean text

The issue is related to storing Korean text, and I am not sure if any specific PHP or MySQL libraries are being used to handle the text (I'll provide access to wordpress, php files and mysql database). The freelancer will need to investigate and identify the root cause of the issue and suggest a solution.

Attached files:
img1: backend to insert words in database.
img2: How Korean words appear in the database
img3: How Korean words appear in frontend

Deliverables:
- Identify the root cause of the collation issue
- Suggest and implement a solution to ensure Korean text is stored correctly in the database

If you have experience with text collation issues and are confident in your ability to solve this problem, please apply!
Related categories: PHP JavaScript AJAX WordPress MySQL