Convert single byte string to double byte string

Question

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 1

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