denny911 Posted May 17, 2007 Share Posted May 17, 2007 helloi use PhpMyAdmin for administering mySql database. when using it, it displays central-european characters (č,ć,đ) way it is supposed. but, when i retrieve my records on my PHP pages, any of those characters is represented as "?" character.during my first installation of MySQL, i set character encoding to UTF-8. but later, after being aware of my problem, i uninstalled it and installed it again, setting encoding to cp-1250 this time.BUT, when i enter PhpMyAdmin, it says MySQL charset is STILL utf-8 !!!!i really dont know what to do. i feel that everything would change if i could change database charset.if there's someone who had this problem, please let me know.Thanks in advance!Denis K. Link to comment Share on other sites More sharing options...
reportingsjr Posted May 17, 2007 Share Posted May 17, 2007 On the first page of PHPMyAdmin isnt there a form to change the encoding? It wouldnt do anything to the database.. Just display the correct letters. Link to comment Share on other sites More sharing options...
denny911 Posted May 17, 2007 Author Share Posted May 17, 2007 On the first page of PHPMyAdmin isnt there a form to change the encoding? It wouldnt do anything to the database.. Just display the correct letters.well, there's no form, i cheched it thousand of times.it just says whats the encoding type and thats all.it seems like the only way to change it is to reinstall mySQL but i've already done that and there wasn't any effect (it still says the charset is utf-8).there must be some way to do it... Link to comment Share on other sites More sharing options...
reportingsjr Posted May 17, 2007 Share Posted May 17, 2007 You're sure? Hmmm, well thats all I could think to do. I'm sure Steve knows what to do . Link to comment Share on other sites More sharing options...
justsomeguy Posted May 17, 2007 Share Posted May 17, 2007 The character set is set per-database, not per-server. In phpMyAdmin, click on the database from the menu, click on the Operations tab, and you can change the collation to cp-1250. Link to comment Share on other sites More sharing options...
denny911 Posted May 19, 2007 Author Share Posted May 19, 2007 The character set is set per-database, not per-server. In phpMyAdmin, click on the database from the menu, click on the Operations tab, and you can change the collation to cp-1250.the thing is, i've already set collation to cp-1250. it still doesnt work, though.there must be some other workaround..any ideas? Link to comment Share on other sites More sharing options...
justsomeguy Posted May 21, 2007 Share Posted May 21, 2007 No, that's the way to do it. If you have the collation set to 1250, and it is saving everything as UTF-8, obviously it's not doing what you asked. You might try checking in the documentation for MySQL or phpMyAdmin, but that would seem like the way to change it. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.