Default character set in database

[pawel jankowski]

Hello!

I have a problem with inserting polish chars into database.
Software is written in c# .net 2005 and I use MySql.Data.dll ver. 5.1.2.2
MySQL version is 5.0.33

When default character set in database is set on 'latin1' all polish chars are replaced by '?' after insert.
Everything went good when default character set is 'utf8'!

BUT!!!

Before insert any record into table, I setup a three variables:
"SET character_set_client = " + sClientCharset;
"SET character_set_results = cp1250;"
"SET character_set_connection = " + sConnCharset;

sClinet.. and sConn... are readed ealier database variables

I wrote small test program in PHP and everything works fine.

Whats wrong??? Plisss help

Best regards