character set encoding problem
Permalink
Hey,
i'm working on a site powered by concrete5. On server were I created that site everything was ok, but when I moved site to another server (I dumped sql DB and imported it to new server) , got a problem with lithuanian characters.After editing content, those simbols converts into question marks. I have checked sql data base. All encodings set to UTF-8, collation to utf-8_general_ci.i guess problem appears when browser sends data to sql DB, because in the tables there are question marks in place of lt symbols.If i write directly into table those symbols don't replace with question marks. Pls help, im looking for answer 3days already, thats why decided to write a post.
i'm working on a site powered by concrete5. On server were I created that site everything was ok, but when I moved site to another server (I dumped sql DB and imported it to new server) , got a problem with lithuanian characters.After editing content, those simbols converts into question marks. I have checked sql data base. All encodings set to UTF-8, collation to utf-8_general_ci.i guess problem appears when browser sends data to sql DB, because in the tables there are question marks in place of lt symbols.If i write directly into table those symbols don't replace with question marks. Pls help, im looking for answer 3days already, thats why decided to write a post.
So made a query in SQL DB:
ALTER `concrete_DB` COLLATE utf8_unicode_ci;
That's all.