Mudsaf Posted January 9, 2013 Share Posted January 9, 2013 (edited) Im having problem with hosting certain files on Apache server. Im currenctly using Website Baker 2.6.7 and having few errors like charset + no login required. (Tested with xampp works, but with apache doesn't work) Have tried everything with charset (DB, Htaccess, Meta .... everything srsly.) Xampp (Lisätietoja:) Lisätietoja: Apache (Lisätietoja:) Lisätietoja: Edited January 9, 2013 by Mudsaf Link to comment Share on other sites More sharing options...
justsomeguy Posted January 9, 2013 Share Posted January 9, 2013 Everything needs to be UTF encoded. You should send content-type headers specifying UTF for each page, have meta tags that say UTF, and save your actual PHP scripts with a UTF encoding. You can also use the multibyte string functions instead of the regular string functions to work with unicode and other multi-byte charsets. Your database tables all should also use UTF for their encoding. Link to comment Share on other sites More sharing options...
Mudsaf Posted January 10, 2013 Author Share Posted January 10, 2013 (edited) Yea but even the login page doesn't work whitout xampp. (Does't display login form and allows users to go trough whitout login).Is there SQL query that could update all my table encoding to UTF-8? The Xampp database had same values as the other since exported the sql-file from xampp host. I guess there could be some problem in apache config or something? Edited January 10, 2013 by Mudsaf Link to comment Share on other sites More sharing options...
Mudsaf Posted January 11, 2013 Author Share Posted January 11, 2013 (edited) BLAAAAAAAAAAARG Nothing works Tried php ini Everything with utf-8 AND ISO-8859-1 php.ini .htaccess meta Saving file as utf-8 Database latin1_swedish_ci latin1_general_ci Nothing works srsly... it was PHP server 5.3. If anyone got fix please inform me. Link here (Website not mine, but had to change location from xampp server to php v5.3) Edited January 11, 2013 by Mudsaf Link to comment Share on other sites More sharing options...
justsomeguy Posted January 11, 2013 Share Posted January 11, 2013 The database charset should be utf8_unicode_ci, not one of the Latin charsets. Link to comment Share on other sites More sharing options...
Mudsaf Posted January 14, 2013 Author Share Posted January 14, 2013 (edited) Srsly nothing works... >_>, can't manage to get any process at my workplace Tried (MySQL) utf8_unicode_cilatin1_swedish_ci Meta (HTML) utf-8ISO-8859-1 PHP.ini utf-8ISO-8859-1 htaccess Don't have code anymore. Saving files to utf8 What can be so different from PHP 5.3 & Xampp Edited January 14, 2013 by Mudsaf Link to comment Share on other sites More sharing options...
birbal Posted January 14, 2013 Share Posted January 14, 2013 Have you checked the default Charset of it in php.ini? Link to comment Share on other sites More sharing options...
Mudsaf Posted January 14, 2013 Author Share Posted January 14, 2013 (edited) No effect ;default_charset = "iso-8859-1" //This is commented i guess.default_charset = "utf-8" --- Does these characters look messed up to you aswell? http://www.nrj.fi/podcasts/?id=2890644 (NRJ-Finland) Edited January 14, 2013 by Mudsaf Link to comment Share on other sites More sharing options...
birbal Posted January 14, 2013 Share Posted January 14, 2013 have you restarted the server? Link to comment Share on other sites More sharing options...
birbal Posted January 14, 2013 Share Posted January 14, 2013 Does these characters look messed up to you aswell? http://www.nrj.fi/podcasts/?id=2890644 (NRJ-Finland)No, it looks fine to me Link to comment Share on other sites More sharing options...
Mudsaf Posted January 14, 2013 Author Share Posted January 14, 2013 How about http://poverihanke.eu/resurssipankki ? Link to comment Share on other sites More sharing options...
rahultailwal Posted January 14, 2013 Share Posted January 14, 2013 All is coming from database right. Can you put the below data how it is stored in database. Like the same as below or looking different. NRJ:n tomituksen työharjoittelija Simo kuulostaa aivan Kotiteollisuuden Jouni Hynyseltä. Mahtoiko homma mennä läpi kun \'Jouni\' soitti Jone Nikulalle ja ehdotti tälle uutta \'Ämmät\' -TV-formaattia.. Link to comment Share on other sites More sharing options...
birbal Posted January 14, 2013 Share Posted January 14, 2013 this one too looks fine. is your problem solved yet? Link to comment Share on other sites More sharing options...
justsomeguy Posted January 14, 2013 Share Posted January 14, 2013 First, stop guessing with the charsets. Everything needs to be UTF-8. Nothing should be Latin, ISO, etc. After you know that everything is UTF-8, then you can add data to the database. The data already there might already be wrong, try adding it again with the correct character set. Link to comment Share on other sites More sharing options...
boen_robot Posted January 14, 2013 Share Posted January 14, 2013 The MySQL connection also needs to explicitly use UTF-8. See mysqli::set_charset(). Link to comment Share on other sites More sharing options...
Mudsaf Posted January 15, 2013 Author Share Posted January 15, 2013 (edited) Yea but even website baker admin panel is messed up when there reads "Ylläpitäjät" (Administrators) and it looks like this Ylläpitäjät . I would assume it doesn't come from Seems like you see NRJ finland same way as i do All is coming from database right. Can you put the below data how it is stored in database. Like the same as below or looking different. NRJ:n tomituksen työharjoittelija Simo kuulostaa aivan Kotiteollisuuden Jouni Hynyseltä. Mahtoiko homma mennä läpi kun \'Jouni\' soitti Jone Nikulalle ja ehdotti tälle uutta \'Ämmät\' -TV-formaattia.. Charset work on both pages at you birbal? this one too looks fine. is your problem solved yet? Anyways the solution worked (Re-writed data in database and it was messed up there, still wondering what happened because works on xampp)First, stop guessing with the charsets. Everything needs to be UTF-8. Nothing should be Latin, ISO, etc. After you know that everything is UTF-8, then you can add data to the database. The data already there might already be wrong, try adding it again with the correct character set. Solved Edited January 15, 2013 by Mudsaf Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now