Page/Character Encoding Tips

[fatihpiristine]

if you are having problems with encoding pages/characters,
try this.

<?php
$servername='localhost';
$dbusername='myusername';
$dbpassword='mypassword';
$dbname='mydatabase';
connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");

if(!$link)
{
die("Could not connect to MySQL");
}
mysql_select_db("$dbname",$link) or die ("could not open database");
}
?>

<?php
$Category_SQL = "select * from mytable";
$Category_Result = mysql_query("SET NAMES 'latin5'");
$Category_Result = mysql_query("SET CHARACTER SET latin5");
$Category_Result = mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
$Category_Result = mysql_query($Category_SQL);

while($Category_Write = mysql_fetch_array($Category_Result))
{
?>
◊ <?php print $Category_Write[1]; ?>

<?php
}
?>

[php_daemon]

Wouldn't it be a better idea to use utf8?

[fatihpiristine]

man.. it works already... it is just an example for those ppl who have problem with encoding. ;)
you can change it to utf

[php_daemon]

I bet it does and thanks for sharing. I've just dropped in another hint in case it doesn't work for someone.

[fatihpiristine]

this one works... enough to collation and character set.

$Category_Result = mysql_query("SET NAMES 'latin5'");
$Category_Result = mysql_query("SET CHARACTER SET latin5");
$Category_Result = mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");