yes msleim thats right. i am still looking for the answer.
and abduraooft yes it is php and mysql...
Here is what I did and you guys tell me what might be wrong:
(as the site needs to be in turkish, but i got many replies that utf8 also works for all the steps below...)
1-I changed the connection collation of the database to: latin5_turkish_ci
2-then I created a new table. I read from somewhere that only new tables created after this change gets affected by the change I do in #1.
3-On that new table, in php my admin, I went into operations tab and changed the collation of the table to latin5_turkish_ci (and all the columns are collated as latin5_turkish_ci)
4-I have two php files, one to update the database and the second one (lets say file2.php) shows info from the database. both files have something like this:
mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
mysql_query("SET NAMES 'latin5_turkish_ci'");
5-in the main page file, which brings up the file2.php via a php include statement, i also have character declaration as:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<link rel="stylesheet" type="text/css" href="css.css" media="all"/>
<meta http-equiv="Content-Type" content="text/html; charset=latin5_turkish_ci" />
(but i dont have this in file2.php that is onnly for bringing up info from database and included in the main page...or should i ?)
So....Can anyone tell me what is wrong here? I even tried manually updating the database with correct characters in phpmyadmin...still it doesnt work...