SQL不保存值ò，à，ù，è[复制]

Question

This question already has an answer here:

• UTF-8 all the way through 15 answers

I have users inserting comments for their courses, and I save them on SQL like this:

$return = $_POST;
$x = $return["comment1"];

$result = "UPDATE  Students SET  `Comment1` =  '$x' WHERE  StudEmail = '$email'  ";

My question is the following: since they are italian, they use letters like: ò,à,ù,è. When SQL saves them, it doesn't recognise them. And obviously, when I print out those comments, it will print them out with a weird symbol.

Any advice?

Example: Comment: Mi è piaciuto SQL saves: Mi � piaciuto

</div>

Answer 1

You would have to search for those chars and replace them with the appropriate ascii value.

This link should help you find the values

http://www.ascii.cl/htmlcodes.htm

For example:

Letter è equals to è

Hope this helps.