advanced code snippet search

Posted By

abdelatifs on 11/02/12


Tagged


Versions (?)

Mysql options

 / Published in: Other
 
Expand | Embed | Plain Text 
  1. [client]
  2. default-character-set=utf8
  3.  
  4. [mysql]
  5. default-character-set=utf8
  6.  
  7. [mysqld]
  8. default-character-set = utf8
  9. collation-server = utf8_unicode_ci
  10. init-connect='SET NAMES utf8'
  11. character-set-server = utf8
  12.  
  13.  
  14.  
  15. and restart mysql:
  16. /etc/init.d/mysqld restart
  17.  
  18.  
  19. to View what charset is in use:
  20. SHOW VARIABLES LIKE "character\_set\_database";

Report this snippet  

You need to login to post a comment.