insert into db, czech language

[luki123]

hi,

i try to insert CZECH text with all these special characters into a mysql db, but when i do that i see only strange characters inside the db table

 

mysql_query("INSERT INTO myTable (Firstname) Values ('ěščřžů ĚŠČŘŽÝÁÍÉŮÚ')");

 

database table row:

Ä›??Ä??™???? Äš? Ä????????????‰?®?š

 

does anyone knows what i have to change (character set?)

 

thanks for helping

 

luki

[Guest prozente]

Something like this

ALTER TABLE `tablename`  DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci;