CODEWITHSUNDEEP
mysqldatabaseencodingutf-8
TIMEX
TIMEX

Reputation: 271844

How do I change mysql settings so that it is default UTF-8 for everything?

I am getting "ASCII encoding" errors when I insert into my database because I did a fresh install of the MYSQL.

I'd like to change the default to UTF-8 again.

This is the error I'm getting because MYSQL is not set in UTF-8 mode:

UnicodeEncodeError: 'ascii' codec can't encode characters in position 0-1: ordinal not in range(128)

Upvotes: 4

Views: 436

Answers (1)

Cristian
Cristian

Reputation: 200100

You can try to put this in your mysql.cfg file:

[mysqld]  
port = 3306 
socket = mysql 
skip-locking 
init_connect='SET collation_connection = utf8_general_ci' 
init_connect='SET NAMES utf8' 
default-character-set=utf8 
character-set-server = utf8 
collation-server = utf8_general_ci 
[mysql] 
default-character-set=utf8

More information:

Upvotes: 1

Related Questions