Convert single byte string to double byte string

encoding, php, unicode

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

Problem

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?

Original source