Page 1 of 1

problem with my sql and encodung

Posted: Sat Oct 07, 2006 11:05 am
by pelegk1
i have php5+mysql5+apache2.2
i am wroking with hebrew and imported all the data that i had im a *.sql file into the mysql db using phpmyadmin.
when i i am opening the project i see all the data retrivied from the db as '?????????' !
what can i do?in the phpmyadmin i see the text ok but for example when i am using SQLyog version 5.1.9 i have the same problem and see all the code as '???"
what can i do?maybe i need to set chages on the apache?
thnaks in advance
peleg

Posted: Sat Oct 07, 2006 11:15 am
by feyd
It sounds like page/character encoding conflicts. A general simple fix is to change the page's encoding specified in the headers and/or the database's encoding for it's storage to a more compatible one.