September 5, 2008 03:20am pdt

1. angelIII 886,168
2. ee_rlee 458,453
3. capricorn1 355,096
4. chapmandew 343,452
5. mark_wills 327,230
6. aneeshatti... 190,096
7. matthews... 187,246
8. Thomasian 170,076
9. jinesh_ka... 167,181
10. sdstuber 149,377
11. jimhorn 131,400
12. peter57r 123,905
13. harfang 111,183
14. DatabaseMX 109,747
15. frankytee 108,644
16. hielo 94,350
17. boag2000 87,538
18. GRayL 85,934
19. TextReport 84,195
20. mwvisa1 79,680
21. ScottPletc... 79,436
22. cactus_d... 77,446
23. dqmq 72,815
24. LSMCons... 68,900
25. dtodd 62,424

1. angelIII 1,631,501
2. capricorn1 689,208
3. matthews... 477,157
4. ee_rlee 458,453
5. aneeshatti... 400,803
6. chapmandew 343,452
7. mark_wills 327,230
8. peter57r 223,934
9. harfang 221,963
10. DatabaseMX 218,819
11. imitchie 215,310
12. jimhorn 211,920
13. dqmq 196,080
14. GRayL 191,765
15. jinesh_ka... 183,470
16. sdstuber 181,875
17. Thomasian 170,076
18. frankytee 158,892
19. Lowfatsp... 148,233
20. mbizup 140,947
21. ScottPletc... 132,541
22. MikeToole 121,533
23. DanielWilson 120,378
24. appari 115,378
25. derekkromm 114,235

04.30.2008 at 05:48PM PDT, ID: 23367354

	[x] Attachment Details

Convert ASCII to UTF-8 during MySQL database import

Asked by benrwms in SQL Query Syntax, PHP Scripting Language, MySQL

Tags: mysql, php, mysql, ASCII, UTF-8, convert

I've exported a WordPress MySQL database using phpmyadmin, but the special characters in the database text, like é, ç and so on, have been changed into ASCII strings. This happens even with certain "normal" characters, like the apostrophe. For instance, the word "Liebenberg's" now shows up as "Liebenbergâ¬"s".

I need to import the database into a new server, and want to convert from ASCII to UTF-8 for special characters during this process, so they show up as normal - but haven't seen a means for doing this.

I think a special script needs to be created to handle the job. I'm not sure how to compose the script for PHP, however, and can't find an ASCII-to-UTF-8 table for it to use.

Any help would be appreciated.Start Free Trial

Keywords: Convert ASCII to UTF-8 during MySQ…

	Title
1	UTF-8 on mysql
2	PHP/MySQL and UTF-8
3	Problem with encoding returned from M…
4	Php utf-8 problem?
5	dreamweaver cs3 recordset problem …
6	Char set problem between PHP and M…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Convert ASCII to UTF-8 during MySQL database import

Asked by benrwms in SQL Query Syntax, PHP Scripting Language, MySQL

Tags: mysql, php, mysql, ASCII, UTF-8, convert

About this solution