Skip to content

Conversation

@julienloizelet
Copy link
Collaborator

Depending on the encoding, the maximum length for VARCHAR in mysql 5.6 is 191.

See https://stackoverflow.com/a/1814594/7497291

@julienloizelet julienloizelet requested a review from rr404 February 9, 2024 09:43
@julienloizelet julienloizelet merged commit 0989573 into crowdsecurity:main Feb 9, 2024
@julienloizelet julienloizelet deleted the feat/add-test-for-sql-database-types branch February 15, 2024 04:25
julienloizelet added a commit to julienloizelet/crowdsec-python-capi-sdk that referenced this pull request Mar 14, 2024
…crowdsecurity#18)

* fix(sql): Add length to machine_id field for mysql compatibility

* ci(test): Add workflow to test sql various engines

* fix(mysql): Decrease machine_id length for mysql 5.6 and prior versions

* ci(test sql): Restrict workflow branch trigger to main

* feat(sql): Change machine_id length to 128
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant