| Index
» Projekty
» phpMyEdit
» Fórum
» UTF-8/special characters/encoding |
 |
weemel
Založený: 15.01.2009
Príspevky: 2
Zaslal: 2009-01-15 13:36
Návrat hore
Odpovedať s citátom
|
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
Založený: 10.02.2003
Príspevky: 1013
Bydlisko: Denver, Colorado (USA)
Zaslal: 2009-01-15 21:44
Návrat hore
Odpovedať s citátom
|
Have you hacked the class file or your db connection and added the necessary UTF8 queries?
| Kód: |
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
Založený: 15.01.2009
Príspevky: 2
Zaslal: 2009-01-16 01:45
Návrat hore
Odpovedať s citátom
|
Yes it worked!!! Thanks soooo much, you're a lifesaver!!!!!! =D Stuck it in the connect function, should be ok eh.
|
doug
Založený: 10.02.2003
Príspevky: 1013
Bydlisko: Denver, Colorado (USA)
Zaslal: 2009-01-16 02:00
Návrat hore
Odpovedať s citátom
|
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
Založený: 10.02.2003
Príspevky: 1013
Bydlisko: Denver, Colorado (USA)
Zaslal: 2009-01-19 14:04
Návrat hore
Odpovedať s citátom
|
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
|
|
Odoslať novú tému
Odpovedať na tému
|
|
|
|
Prihlásiť
Registrácia
English
