weird chars stored into database

[F_W]

Hello

I'm developing a website written in PHP
the website uses MySQL to store data

the website is developed mainly with dreamweaver, and handcoded where necessary

when I send data from a form to the database, if the content of the form field (textarea) contains chars like èòàùì they're written to the database as è, ò, à ,ù and visualized in html pages as little squares

the database field where this text is stored is a text field, latin1_swedish_ci (hence if I'm correct it should support òàùèì)
I have tried with utf8_unicode_ci as well, no difference

if I print those chars on the page before executing the insert they are ok, it seems like the are 'corrupted' while being sent to the database

the page where I fill the form is UTF-8

any ideas?

[mkoenig]

May be your character set, but may also be that you are copy and pasting from Word or something similar.

that always gives me strange characters.

[coolR]

You can delimit unsupported characters using this code.

if(!ereg('^[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+'. '@'.'[-!#$%&\'*+\\/0-9=?A-Z^_`a-z{|}~]+\.'.'[-!#$%&\'*+\\./0-9=?A-Z^_`a-z{|}~]+$',$inserttextintodb))
   {
      echo 'unsuported characters.';
   }
else
{
mysql_query('INSERT INTO ........');
}

[falsealarm]

I believe the declaration on the page, code and database need to match for the foreign character displays to work as expected. A script that I was running gave me some headache sometime ago and this was the case. You just need to make sure that all parts play on the same characterset