Can I Convert this utf8 Character?

Question

I am using dom htm document function to scrape html and store it into MySQl. but I have notieced that for foriegn languages like chinese or japanese etc. some wierd charactors are stored in MySQL and I dont think any one can read this..,é—¨æˆ·,æ–°é—»,ãƒ¼ã‚¿ãƒ«,æ¤œç´¢

so my question is can I convert this back into original form by using any code??

if not I want to eliminate this from my table beacuse there is no use of it.how can I eliminate only these charactors from table??

@leon the default collation for tables is latin1_swedish. Can you confirm that your *tables* are UTF-8? — Pekka, Jan 27 '11 at 11:33
At some point, the input gets converted into (probably) a single-byte encoding like ISO-8859-1. Note that the database connection from within a script is usually ISO encoded and not UTF-8 — Pekka, Jan 27 '11 at 11:46
@leon you need to find out where the problem is. Maybe sending a query `SET NAMES utf8;` after making the database connection helps — Pekka, Jan 27 '11 at 11:58
Perharps they are stored correctly and the problem is your output encoding. — user570783, Jan 27 '11 at 12:18
This question should tell you all you need to know: http://stackoverflow.com/questions/279170/utf-8-all-the-way-through — mercator, Jan 27 '11 at 16:47

score 0 · Accepted Answer · answered Jan 27 '11 at 16:38

0

This should do the trick if the input is actually UTF-8:

echo iconv('UTF-8', 'ASCII//IGNORE', 'news,é—¨æˆ·,æ–°é—»,portal,ç½‘æ˜“,163,china,é—¨æˆ·ç');

answered Jan 27 '11 at 16:38

Álvaro González

142,137
41
261
360

score -2 · Answer 2 · answered Jan 27 '11 at 11:33

-2

Best way is to store this data after doing base64 encoding

1.) UNICODE TO UTF8

2.) UTF8 TO BASE64

answered Jan 27 '11 at 11:33

Hoshin

454
3
14

Base64?? this isnt any encryption...I am not used any base64 encoding for data storage.. – leon Jan 27 '11 at 11:40

Can I Convert this utf8 Character?

2 Answers2

Linked