New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

0008708: switch to mysql utf8mb4 #4378

Closed
Gloirin opened this Issue Jun 9, 2018 · 3 comments

Comments

Projects
None yet
1 participant
@Gloirin

Gloirin commented Jun 9, 2018

Reported by pschuele on 31 Jul 2013 14:27

switch to mysql utf8mb4

  • to add full (4 byte) unicode charset support

Additional information: http://mathiasbynens.be/notes/mysql-utf8mb4

@Gloirin

This comment has been minimized.

Show comment
Hide comment
@Gloirin

Gloirin Jun 10, 2018

Comment posted by pschuele on 24 Apr 2018 10:19

https://gerrit.tine20.com/customers/#/c/8923/

Gloirin commented Jun 10, 2018

Comment posted by pschuele on 24 Apr 2018 10:19

https://gerrit.tine20.com/customers/#/c/8923/

@Gloirin

This comment has been minimized.

Show comment
Hide comment
@Gloirin

Gloirin Jun 10, 2018

Comment posted by pschuele on 24 Apr 2018 10:20

We changed the default charset to UTF8MB4. All tables in the Tine 2.0 Database are converted during
the Update. This requires either MySQL 5.7.7+ or MariaDB 10.2.2+ with default settings. Earlier versions are supported
with non default settings. MySQL 5.6+ and MariaDB 10.0+ need to set:
innodb_large_prefix = 1
innodb_file_format = 'Barracuda'
innodb_file_per_table = 'ON'
The update script will test these settings and abort if prerequisites are not met.

Gloirin commented Jun 10, 2018

Comment posted by pschuele on 24 Apr 2018 10:20

We changed the default charset to UTF8MB4. All tables in the Tine 2.0 Database are converted during
the Update. This requires either MySQL 5.7.7+ or MariaDB 10.2.2+ with default settings. Earlier versions are supported
with non default settings. MySQL 5.6+ and MariaDB 10.0+ need to set:
innodb_large_prefix = 1
innodb_file_format = 'Barracuda'
innodb_file_per_table = 'ON'
The update script will test these settings and abort if prerequisites are not met.

@Gloirin

This comment has been minimized.

Show comment
Hide comment
@Gloirin

Gloirin Jun 10, 2018

Comment posted by pschuele on 24 Apr 2018 10:20

http://gerrit.tine20.com/customers/9003

Gloirin commented Jun 10, 2018

Comment posted by pschuele on 24 Apr 2018 10:20

http://gerrit.tine20.com/customers/9003

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment