I have a database full of Unicode strings and now I need a function to convert and show them.
This is my current string:
\u062f\u0648\u0646\u0647 \u0645\u0646\u2665\u2665\u2665\u2665
And this is expected output:
دونه من♥️♥️♥️♥️
Asked
Active
Viewed 298 times
2
-
change your column datatype to `Blob` in database table its should show the what you outpput you expected – Ashok Chandrapal Oct 15 '16 at 07:56
-
@AlbertAkki Actually I don't have access to the database,It's Off-the-shelf and I should retrieve values from it. – Hamidreza Noruzinejad Oct 15 '16 at 08:00
-
set php header then. like ` ` wherever you want to show the result – Ashok Chandrapal Oct 15 '16 at 08:02
-
@AlbertAkki just tried but no use. – Hamidreza Noruzinejad Oct 15 '16 at 08:05
-
@ Hamidreza Noruzinejad, then i would suggest to make change in database table. just take access of database and change the datatype – Ashok Chandrapal Oct 15 '16 at 09:27
-
@AlbertAkki Thanks, check my solution. – Hamidreza Noruzinejad Oct 15 '16 at 10:32
-
Where is `\u....` coming from? If you can get that to be `UTF-8` instead, then several things will be simpler. – Rick James Oct 21 '16 at 03:39
-
Is the column in the table declared `CHARACTER SET utf8mb4`? Without that, all the suggestions will be for naught. Let's see `SHOW CREATE TABLE`. – Rick James Oct 21 '16 at 03:40
-
Eh? I don't see any utf8mb4 here. `\u....` is Unicode, not utf8mb4. Maybe the title needs changing? – Rick James Oct 21 '16 at 03:44
-
@RickJames you are right , thanks for noticing. – Hamidreza Noruzinejad Oct 22 '16 at 10:24
1 Answers
0
preg_replace_callback('/\\\\u([0-9a-fA-F]{4})/',
function ($match) {
return mb_convert_encoding(pack('H*', $match[1]), 'UTF-8', 'UCS-2BE');
}, '\u062f\u0648\u0646\u0647 \u0645\u0646\u2665\u2665\u2665\u2665');