I want the string Game to convert пј§пЅЃпЅЌпЅ…. This string is a Japanese double byte string.
Is it possible to achieve this using PHP? If so, how?
Answer
Solution:
First of all, пј§пЅЃпЅЌпЅ… is not ASCII charset, so you might need to set the page Content-type header to see a proper output:
header("Content-type: text/html; charset=utf-8");
Then you can convert it using this function
echo mb_convert_kana('Game', "R", 'UTF-8')
EDIT:
For MySQL I couldn't find a converter to do the same. However, you can still convert it manually on the Hex level, for example, you can get the word пј§пЅЃпЅЌпЅ… like this
SELECT CHAR(0xefbca7, 0xefbd81, 0xefbd8d, 0xefbd85) as `Full Width`;
So, we can just write a mapping function in MySQL that replaces the characters using this table
Answer
Solution:
Well, can't say for sure whether I got your question right, but the following console one-liner: