/SQL/Sql change default collation to utf8

Sql change default collation to utf8

Sql change default collation to utf8

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

0

Source: stackoverflow.com

Similar codes

3 votes245 views1 answer
Oracle sleep
SQL
25 votes251 views6 answers
Import database mysql command line
SQL
8 votes227 views1 answer
Mac restore mysql database command line
SQL
0 vote268 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
23 votes259 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote230 views2 answers
SQL Server Standard
SQL
0 vote235 views1 answer
Get records in sql according to month name and count
SQL
0 vote236 views1 answer
User defined variables in sql
SQL
0 vote235 views1 answer
Soql user profile
SQL
0 vote242 views1 answer
Sqlalchemy case insensitive like
SQL

Share