Skip to content
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鈥檒l occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Investigate switchover to utf8mb4 MySQL charset #1

Closed
drn05r opened this issue Mar 26, 2021 · 0 comments
Closed

Investigate switchover to utf8mb4 MySQL charset #1

drn05r opened this issue Mar 26, 2021 · 0 comments
Assignees
@drn05r
Labels
enhancement New feature or request
Milestone
3.5.0

Comments

@drn05r
Copy link

drn05r commented Mar 26, 2021

Investigate switching over from utf8 to utf8mb4 MySQL charset in order to support 32-bit Unicode characters, such as 饾挭 (mathematical script capital O).

This will require changing SET NAMES call in perl_lib/EPrints/Database/mysql.pm as well as looking at the EPrints API for creating database table fields from EPrint MetaFields for certain types. It is also worth investigating adding a function so when upgrading to 3.4.4 and running "epadmin upgrade" appropriate fields are updated to use utf8mb4 charset.
@drn05r drn05r added the enhancement New feature or request label Mar 26, 2021
@drn05r drn05r self-assigned this Mar 26, 2021
@drn05r drn05r transferred this issue from eprints/eprints3.4 Jun 22, 2023
@drn05r drn05r added this to the 3.5.0 milestone Jun 22, 2023
drn05r added a commit that referenced this issue Jun 22, 2023
@drn05r
Allows dbcharset to be set to address #1
f16f45b
@drn05r drn05r closed this as completed in 83a0a2c Jun 23, 2023
drn05r added a commit that referenced this issue Jul 6, 2023
@drn05r
Fixes bug created by #1
3d0b127 
Using DBD::MySQL mysql_enable_utf8mb4 breaks some two bytes characters.
This flag does not look like it needs to be set to actually use UTF8-MB4.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@drn05r drn05r

Labels
enhancement New feature or request
Projects
None yet
Milestone
3.5.0
Development

No branches or pull requests
1 participant
@drn05r