Mysql collation issue?

I recently ran into an issue that I can't figure out

We have a client who just setup a greek site. On a certain page, he has some links which are being pulled from a MySQL database. When you view those links on the page, you only see ??????? instead of the actual letters.

I'm pretty sure it has something to do with php and mysql, as far as encoding and collation goes. However, I am not sure how to fix this issue.

We are currently running the following:

PHP 4.4.1
Apache 1.3.34
MySQL 4.1.14

He tested this site on a different server and it worked. The second server's system is as follows:

PHP 4.3.11
Apache 2.0.46
MySQL 3.23.58

Within phpMyAdmin, the greek letters do show up, so it is something with the encoding in MySQL.

Any ideas on how I can go about showing the actual greek letters to show up instead of the ????? ??

Thanks for your help

 

 

 

 

Top