CODEWITHSUNDEEP
mysqlutf-8utf8mb4
credo56
credo56

Reputation: 433

MySQL DB not handling non-latin characters properly

I'm seeing usernames of newly created accounts like 'कविता हेमनà¥à¤¤' within the database itself. From some digging I know that these names are just Facebook account names (I allow Facebook log in) but in non-latin scripts.

I've configured my MySQL db to work in 'utf8mb4' but this doesn't seem to let the names be stored in their original scripts.

Edit: I'm using PHP. On initial connection to the database I specify utf-8mb4 as the encoding but do not specify encoding on the query level.

Upvotes: 0

Views: 861

Answers (1)

Rick James
Rick James

Reputation: 142560

That is Mojibake for कविता हेमन. See Trouble with utf8 characters; what I see is not what I stored and look for "Mojibake". It discusses the problem and the likely causes. See also "Best Practice".

Either utf8 or utf8mb4 suffices. That is, this is not a utf8mb4-specific problem.

Upvotes: 1

Related Questions