Hi, When my users create new mysql db, their collation of db is latin1swedish ci. Now, I want to change the default collation to utf8generalci. Could you help me? many thanks. CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8generalci GRANT ALL ON mydb. TO usernamelocalhost IDENTIFIED BY password Alternatively, you can use CREATE SCHEMA instead of CREATE DATABASE I cant get the UTF-8 charset to work and I get instead of . Yes, I have searched around the web for answers and Ive already used the following codeThe database uses latin1swedishci. Any idea what it could be? To declare character encodings in HTML documents add, the following in the head section of HTML documents: for HTML5 and . and this.use "setcharset" function after connecting to Mysql database. See also questions close to this topic. The character set defined for this page is http-equiv"Content-Type" content"text/ html charsetUTF-8".
See "LINKS/ OTHER RESOURCES" below for complete character lists. Selected character reference mysqlquery ("setclientutf8")//Следующие 4 строки решают проблему с кодировкой.mysqlquery ("set collationconnectionutf8generalci") You can also use a meta tag that is redundant in theory