![]() ![]() To do this, you can use a text editor such as Vim or Nano. To convert the character encoding set to UTF- 8: Make sure that you back up the database before you start this procedure! You can back up a MySQL database using cPanel, phpMyAdmin, or the mysqldump program. To exit the mysql program, type \q at the mysql> prompt.Ĭonverting the character encoding set to UTF- 8.SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE llation_name = T.table_collation AND T.table_schema = " dbname" AND T.table_name = " tablename" Replace dbname with the database name, and tablename with the name of the table: To display the current character encoding set for a particular table in a database, type the following command at the mysql> prompt. SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = " dbname" To display the current character encoding set for a particular database, type the following command at the mysql> prompt. ![]() When you type the correct password, the mysql> prompt appears. At the Enter Password prompt, type your password.At the command line, type the following command, replacing username with your username:.To determine which character encoding set a MySQL database or table is currently using: Converting the character encoding set to UTF- 8ĭetermining the current character encoding set.Determining the current character encoding set. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |