Hello everyone,

I am starting with my PHP adventure with this tutorial:

http://www.phazm.com/notes/easy-as-pie/eas...with-databases/

Everything works fine, but when I add to database string with Polish characters (like ą, ż, ź, ć, ę, ł), I don't see them on site, instead of them I see strange characters.

When I add to database through phpMyAdmin with Polish characters (like ą, ż, ź, ć, ę, ł) I see those characters in my table/rows correct (through phpMyAdmin).

But when I'm displaying data on my site I again see those strange characters instead of Polish ones.

MySQL Collation is utf8_bin (I also tired utf8_unicode_ci without success).

I use this code:

Code:
<html>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Language" content="pl" />

</head>
<body>

<?php
$user="username";
$password="password";
$database="database";
$connection=mysql_connect('localhost',$user,$password);
@mysql_select_db($database) or die( "Unable to select database");

if ($_REQUEST['quote'] != "") {
	if($_REQUEST['author'] != "") {
		$author = $_REQUEST['author'];
	} else {
		$author = "Anonymous";
	}
	$quote = $_REQUEST['quote'];
	
	$query="INSERT INTO `quotes` (`quote`,`author`) values ('" . mysql_real_escape_string($quote) . "','" . mysql_real_escape_string($author) . "')";
	
	$result=mysql_query($query) or die(mysql_error());
	echo("inserted quote: " . htmlentities($quote) . " by " . htmlentities($author) . " into database");
}  else {
	echo("<p>Please enter a quote and author</p>");
}
?>
<form action="" method="post">
<fieldset>
<legend>Add a Quote</legend>
<label for="quote">Quote:</label>
<input type="text" name="quote" id="quote" maxlength="255" />
<label for="author">Author:</label>
<input type="text" name="author" id="author" maxlength="40" />
<input type="submit" value="Add Quote" />
</fieldset>
</form>

<h2>All Quotes:</h2>
<?php

$query="SELECT `quote`, `author` FROM `quotes`";
$result=mysql_query($query) or die(mysql_error());
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$quote = htmlentities(mysql_result($result,$i,"quote"));
$author = htmlentities(mysql_result($result,$i,"author"));
echo("<blockquote>" . $quote . " ~ <cite>" . $author . "</cite></blockquote>");
$i++;
}
mysql_close($connection);
?>