| Index
» Projects
» phpMyEdit
» Forum
» UTF-8/special characters/encoding |
 |
weemel
Joined: 15 Jan 2009
Posts: 2
Posted: 2009-01-15 13:36
Back to top
Reply with quote
|
Hi there,
I have a utf-8 mysql database and am trying to use phpMyEdit to update it... for some reason phpMyEdit does not display (either for the records, or updating via the form) special characters correctly, even though i've stuck
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<meta http-equiv="charset" content="UTF-8">
in the head for the individual page (for a particular table). Anyone have any ideas where i may have gone wrong?
Much appreciated!
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2009-01-15 21:44
Back to top
Reply with quote
|
Have you hacked the class file or your db connection and added the necessary UTF8 queries?
| Code: |
mysql_query('SET NAMES UTF8');
mysql_query('SET COLLATION_CONNECTION=UTF8_GENERAL_CI'); |
For teh language labels, you might also need to hack the language files and apply urlencode() to values containing accented characters.
|
weemel
Joined: 15 Jan 2009
Posts: 2
Posted: 2009-01-16 01:45
Back to top
Reply with quote
|
Yes it worked!!! Thanks soooo much, you're a lifesaver!!!!!! =D Stuck it in the connect function, should be ok eh.
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2009-01-16 02:00
Back to top
Reply with quote
|
When converting my work to UTF-8, it took about 2 days of trial and error to figure out various problems. Thus I'll post the following link, for the benefit of other users who may find this information helpful:
http://www.oreillynet.com/onlamp/blog/2006/01/turning_mysql_data_in_latin1_t.html
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2009-01-19 14:04
Back to top
Reply with quote
|
If you have control over your server's MySQL startup process, the following link may be useful:
http://www.saiweb.co.uk/mysql/mysql-forcing-utf-8-compliance-for-all-connections
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
