# mysqlclient-collate
**NOTE:** These features have been merged upstream into mysqlclient 2.2.0. This package is now archived. Please switch to `mysqlclient>=2.2` instead.
---
Fork of [mysqlclient](https://github.com/PyMySQL/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:
* [mysqlclient bug report](https://github.com/PyMySQL/mysqlclient/pull/564)
* [Wagtail bug report](https://github.com/wagtail/wagtail/issues/9477)
## 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:
```python
DATABASES = {
"default": {
"ENGINE": "django.db.backends.mysql",
"HOST": "",
"NAME": "",
"USER": "",
"PASSWORD": "",
"OPTIONS": {
"charset": "utf8mb4",
"collation": "utf8mb4_unicode_ci",
},
}
}
```
Raw data
{
"_id": null,
"home_page": "https://github.com/coderedcorp/mysqlclient-collate",
"name": "mysqlclient-collate",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.5",
"maintainer_email": "",
"keywords": "",
"author": "CodeRed LLC",
"author_email": "info@coderedcorp.com",
"download_url": "https://files.pythonhosted.org/packages/8c/6f/ae76ffe0dc52ec56697bbdec0879befc57e7d8c69a8201c7ac276c755c11/mysqlclient-collate-2.1.1.post2.tar.gz",
"platform": "ALL",
"description": "# mysqlclient-collate\r\n\r\n**NOTE:** These features have been merged upstream into mysqlclient 2.2.0. This package is now archived. Please switch to `mysqlclient>=2.2` instead.\r\n\r\n---\r\n\r\nFork of [mysqlclient](https://github.com/PyMySQL/mysqlclient) which adds support for setting collation via connection options.\r\n\r\nSetting 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:\r\n\r\n* [mysqlclient bug report](https://github.com/PyMySQL/mysqlclient/pull/564)\r\n* [Wagtail bug report](https://github.com/wagtail/wagtail/issues/9477)\r\n\r\n## Usage\r\n\r\nMake sure you have MySQL or MariaDB C connector, and a C compiler installed.\r\n\r\n**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.\r\n\r\n```\r\npip uninstall mysqlclient\r\npip install mysqlclient-collate\r\n```\r\n\r\nFor use in a Django project, set your database connection as so:\r\n\r\n```python\r\nDATABASES = {\r\n \"default\": {\r\n \"ENGINE\": \"django.db.backends.mysql\",\r\n \"HOST\": \"\",\r\n \"NAME\": \"\",\r\n \"USER\": \"\",\r\n \"PASSWORD\": \"\",\r\n \"OPTIONS\": {\r\n \"charset\": \"utf8mb4\",\r\n \"collation\": \"utf8mb4_unicode_ci\",\r\n },\r\n }\r\n}\r\n```\r\n",
"bugtrack_url": null,
"license": "GPL",
"summary": "Python interface to MySQL",
"version": "2.1.1.post2",
"project_urls": {
"Homepage": "https://github.com/coderedcorp/mysqlclient-collate"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "d09a147bce3c8ffa72da6b1ec067c478bf191b0cc6c3c79af4adaa4fa77919f4",
"md5": "b825ac4d2f01833153ec0150ac1598fa",
"sha256": "7884c06f23d731676916d2a36d021a5669d374f99f8888c91ef47c4a949d6bfc"
},
"downloads": -1,
"filename": "mysqlclient_collate-2.1.1.post2-cp310-cp310-win_amd64.whl",
"has_sig": false,
"md5_digest": "b825ac4d2f01833153ec0150ac1598fa",
"packagetype": "bdist_wheel",
"python_version": "cp310",
"requires_python": ">=3.5",
"size": 173548,
"upload_time": "2023-10-19T15:31:38",
"upload_time_iso_8601": "2023-10-19T15:31:38.793383Z",
"url": "https://files.pythonhosted.org/packages/d0/9a/147bce3c8ffa72da6b1ec067c478bf191b0cc6c3c79af4adaa4fa77919f4/mysqlclient_collate-2.1.1.post2-cp310-cp310-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "c7fa954f2bd46dc9ab3526bdaf59ae4c9dfb5bb89524dfe75cdc23283bb3ed76",
"md5": "13bada219bef3aabc842013834966f33",
"sha256": "d67d1eed148a5ae7e955f2fc1b6167f6dc385d8b812078b9cebc5863adc9a9ff"
},
"downloads": -1,
"filename": "mysqlclient_collate-2.1.1.post2-cp311-cp311-win_amd64.whl",
"has_sig": false,
"md5_digest": "13bada219bef3aabc842013834966f33",
"packagetype": "bdist_wheel",
"python_version": "cp311",
"requires_python": ">=3.5",
"size": 173551,
"upload_time": "2023-10-19T15:31:40",
"upload_time_iso_8601": "2023-10-19T15:31:40.628613Z",
"url": "https://files.pythonhosted.org/packages/c7/fa/954f2bd46dc9ab3526bdaf59ae4c9dfb5bb89524dfe75cdc23283bb3ed76/mysqlclient_collate-2.1.1.post2-cp311-cp311-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "b50e0bbbf04ca2340e8d49d74868fa68bde58d5cf09540f8f27970d230724763",
"md5": "987a3b5dc9917ae121fcba67aac6e674",
"sha256": "e071c70aff80181989fe4d0f6c09c57530b4f42bdb13be43387b42bb2d730bc3"
},
"downloads": -1,
"filename": "mysqlclient_collate-2.1.1.post2-cp37-cp37m-win_amd64.whl",
"has_sig": false,
"md5_digest": "987a3b5dc9917ae121fcba67aac6e674",
"packagetype": "bdist_wheel",
"python_version": "cp37",
"requires_python": ">=3.5",
"size": 174145,
"upload_time": "2023-10-19T15:31:42",
"upload_time_iso_8601": "2023-10-19T15:31:42.389870Z",
"url": "https://files.pythonhosted.org/packages/b5/0e/0bbbf04ca2340e8d49d74868fa68bde58d5cf09540f8f27970d230724763/mysqlclient_collate-2.1.1.post2-cp37-cp37m-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "0aacb2cfbefbb08835d019a3c187e976f6ae834afb4bb1d09db27183aa708a36",
"md5": "080a59c9689f823bc48ad2c86a0613b9",
"sha256": "2429c9915ae10e5fb16a9d8c7f9de9d542c70c4c35861f403121d4beb5a83c01"
},
"downloads": -1,
"filename": "mysqlclient_collate-2.1.1.post2-cp38-cp38-win_amd64.whl",
"has_sig": false,
"md5_digest": "080a59c9689f823bc48ad2c86a0613b9",
"packagetype": "bdist_wheel",
"python_version": "cp38",
"requires_python": ">=3.5",
"size": 174488,
"upload_time": "2023-10-19T15:31:43",
"upload_time_iso_8601": "2023-10-19T15:31:43.896086Z",
"url": "https://files.pythonhosted.org/packages/0a/ac/b2cfbefbb08835d019a3c187e976f6ae834afb4bb1d09db27183aa708a36/mysqlclient_collate-2.1.1.post2-cp38-cp38-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "ed5a24a051d68fb23b4a02a21301e3845772239a038d9357a159d311993ade2a",
"md5": "67dbb43fee7c31e2087a2b8457e4ac8a",
"sha256": "faa37c715858d0b486448a1236b1ad5ff008b5f8a2a0b383e0b72d4f353f6718"
},
"downloads": -1,
"filename": "mysqlclient_collate-2.1.1.post2-cp39-cp39-win_amd64.whl",
"has_sig": false,
"md5_digest": "67dbb43fee7c31e2087a2b8457e4ac8a",
"packagetype": "bdist_wheel",
"python_version": "cp39",
"requires_python": ">=3.5",
"size": 174477,
"upload_time": "2023-10-19T15:31:45",
"upload_time_iso_8601": "2023-10-19T15:31:45.716981Z",
"url": "https://files.pythonhosted.org/packages/ed/5a/24a051d68fb23b4a02a21301e3845772239a038d9357a159d311993ade2a/mysqlclient_collate-2.1.1.post2-cp39-cp39-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "8c6fae76ffe0dc52ec56697bbdec0879befc57e7d8c69a8201c7ac276c755c11",
"md5": "75cfbf8efc38e2c6cace547539209d9d",
"sha256": "6c98e4e2cb8863898ce4c2b590d8ed44e8b33165f12d77556c34f8bb6a14aab4"
},
"downloads": -1,
"filename": "mysqlclient-collate-2.1.1.post2.tar.gz",
"has_sig": false,
"md5_digest": "75cfbf8efc38e2c6cace547539209d9d",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.5",
"size": 87152,
"upload_time": "2023-10-19T15:31:47",
"upload_time_iso_8601": "2023-10-19T15:31:47.615750Z",
"url": "https://files.pythonhosted.org/packages/8c/6f/ae76ffe0dc52ec56697bbdec0879befc57e7d8c69a8201c7ac276c755c11/mysqlclient-collate-2.1.1.post2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-10-19 15:31:47",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "coderedcorp",
"github_project": "mysqlclient-collate",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "mysqlclient-collate"
}