How to use default-character-set in django - mysql database connection

Question

So, I was re-configuring my SQL and decided to move back from my.conf to settings.py (context: https://docs.djangoproject.com/en/3.2/ref/databases/#mysql-notes)

'read_default_file': '/path/to/my.cnf',

# my.cnf
[client]
database = NAME
user = USER
password = PASSWORD
default-character-set = utf8

So I was shifting from my.conf to settings.py I got an error

TypeError: 'default-character-set' is an invalid keyword argument for connect

My code:

'Options':{
      'default-character-set': utf8
      }

nbk · Accepted Answer · 2021-06-18 21:56:02Z

1

The option is charset

'Options':{
    'charset': 'utf8mb4'
}

answered Jun 18, 2021 at 21:56

nbk

49.6k8 gold badges32 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user16241015 Over a year ago

Why it's different from the one in my.cnf?

nbk Over a year ago

as you error smessage stated, your option 'default-character-set' is not known, mybe it is because of the added white space, but i couldn't find any mention that such option exists, mine does, so use it and program after your hearts ontent

user16241015 Over a year ago

Using charset does work for me. I have tried removing the spaces it didn't work

Collectives™ on Stack Overflow

How to use default-character-set in django - mysql database connection

1 Answer 1

3 Comments

Your Answer

Collectives™ on Stack Overflow

How to use default-character-set in django - mysql database connection

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related