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?
-
Use mb_convert_encoding() with the appropriate encodingsMark Baker– Mark Baker2014-03-22 10:21:45 +00:00Commented Mar 22, 2014 at 10:21
-
@MarkBaker : i would try this mb_convert_encoding() for php but in mysql part... is there any function for this ? because my probable solution would be base on the query directly..stryker– stryker2014-03-22 11:21:43 +00:00Commented Mar 22, 2014 at 11:21
-
If you need to do this in MySQL, then use CONVERT() or CAST()Mark Baker– Mark Baker2014-03-22 11:28:39 +00:00Commented Mar 22, 2014 at 11:28
-
What encoding? UTF-16?tadman– tadman2014-04-10 04:27:48 +00:00Commented Apr 10, 2014 at 4:27
-
@tadman: this is more likely to be UTF8 => SJIS-win in PHP. or utf8 => sjis(Shift-JIS Japanese) in MySQLstryker– stryker2014-04-10 10:11:44 +00:00Commented Apr 10, 2014 at 10:11
Add a comment
|
3 Answers
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
1 Comment
stryker
@KraneBird: thanks for your answer in php part... but how about in mysql part, is there any way to achieve this ?
Well, can't say for sure whether I got your question right, but the following console one-liner:
$ php -r 'var_dump(mb_convert_encoding("Game", "UCS-2"));'
gives me the following:
string(8) "\000G\000a\000m\000e"
Is this what you want? As Mark Baker already said, it's just the case of mb_convert_encoding for you.
3 Comments
Amal
How would you determine which encoding to use? Using mb_detect_encoding perhaps?
hijarian
Man, but you are going to convert to the multibyte encoding! I assume that you have control over the input string, and you know to what encoding you want to convert! Use Shift-JIS, for example, or EUC. I have used UCS-2 because it's guaranteed to be exactly two-byte Unicode encoding, as you have specified.
Amal
This doesn't still convert
Game => Ｇａｍｅ.
1 Comment
stryker
this is in contrast of what i've wanted to be converted. i want this kind of conversion 'Game' => 'Ｇａｍｅ'