Python interface to MySQL
Project description
mysqlclient-collate
Fork of mysqlclient which adds support for setting collation via connection options.
Setting collation is necessary for servers that do not use the default, and for Django queries using CAST
statements, which are prevalent in Wagtail 4. For more background, see the following discussions:
Usage
Make sure you have MySQL or MariaDB C connector, and a C compiler installed.
IMPORTANT: If you already have mysqlclient
installed, uninstall it before installing this fork. Both projects use the same module name and cannot be installed at the same time.
pip uninstall mysqlclient
pip install mysqlclient-collate
For use in a Django project, set your database connection as so:
DATABASES = {
"default": {
"ENGINE": "django.db.backends.mysql",
"HOST": "",
"NAME": "",
"USER": "",
"PASSWORD": "",
"OPTIONS": {
"charset": "utf8mb4",
"collation": "utf8mb4_unicode_ci",
},
}
}
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Hashes for mysqlclient-collate-2.1.1.post1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | f59e8d9c7e898bd69567d5257654ab77b6b9d4b50d89ef5f7ad3ef448d7a3ce3 |
|
MD5 | cabc01875533716caebf5c04297cad0a |
|
BLAKE2b-256 | 6aa0d4f3d67a4ebb4b63056e051a2c5089319ab89e5c62f58b26df43d131d169 |
Hashes for mysqlclient_collate-2.1.1.post1-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 919e503f9974b04d9a8f51b26c05d724e0e40d791b6014cc1ab41ffd4d9630aa |
|
MD5 | be05dd3d31a752c19f82b3ac1e2c5b35 |
|
BLAKE2b-256 | 80669a12d336a419000d9d0ad2d404bd01a4e4fd9501f7d1b11742ed2273b854 |
Hashes for mysqlclient_collate-2.1.1.post1-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 32f8b58231f6b060ba626abea98a45156fbac96f7477b8c781e8e29e25c6367c |
|
MD5 | 56a630265b8d2e01a91eb68762ff7fbd |
|
BLAKE2b-256 | b95912aaa0d2db2369ff03a8f6137f59125c275a898a491ee74f4de252e02cfd |
Hashes for mysqlclient_collate-2.1.1.post1-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a62b80a83abe9cdc55e3b31ed3816b339f9a4a7482c0b0e9c2e8bd5f4281ced5 |
|
MD5 | 2759352c94e432516132affcb7d44af6 |
|
BLAKE2b-256 | 842d1d24f5eff1e76080d9f4903945f7634b21269f864b45dc4694d6bc65b20d |
Hashes for mysqlclient_collate-2.1.1.post1-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 94b85e54795414fc26098b2a306731c789fcb306d5fb4cf47bf1fc5ed1d00296 |
|
MD5 | dee1dc5e744eee692accd6430c3b0b57 |
|
BLAKE2b-256 | b179344ce2f09d4560a8fd196d681fce64ffd4dc1b4e6a878c4a918ba5483153 |
Hashes for mysqlclient_collate-2.1.1.post1-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 55a96c9c68f6f4e6247186afa0e3a590a54905a0d54e56848676440621e748eb |
|
MD5 | 31ea1e936be713a1a59ff6855b6b4fd2 |
|
BLAKE2b-256 | 68581ee0f85845d07db932db06ab2d875bbdf1962be6639c33c1bc07a438a6b8 |