Some strange problems with database - anyone other faced?

[Mysterio]

Hello guys,

I am facing some strange problems working on database!

One is, wrong displaying of characters. When I created a website in my localhost, i can save non-ASCII characters in database and deal as I want with them, but when I moved the site to a live server, those characters are not displaying as expected.

Another problem is, I can insert whatever data using the "INSERT" query, but when it comes to "UPDATE" it doesn't work and no error is being showed. Does the characters has to do with this?

Thanks in advance!

[something else]

Sounds like you are using the wrong character encoding
i would try something like:

ALTER TABLE table CHANGE column column TEXT CHARACTER SET utf8; 

Added after 4 minutes:

may be easier to just recreate the tables to utf8.... rather than do it for each column

[kei_ki7]

Also try to change the encoding in header

[Mysterio]

Thank you guys,
tried already - no result!

I note that in local server is everything ok, this happens in live server only where the site is only moved with Filezilla and database imported using SQLYog.
Does server configurations has to do with it?