search

vivo-community / vivo-docker2

Dockerized VIVO
Apache License 2.0
8 stars 16 forks source link

Current docker image with Mariadb doesn't support 4byte unicode #5

Open delsborg opened 5 years ago

delsborg commented 5 years ago

The mysql-init.sql file creates the database with: CREATE DATABASE vitrodb CHARACTER SET utf8;

This does not allow extended unicode to be uploaded. Researching this issue it looks like the DB should be created with utf8mb4.

I've attached the rdf that I tried to update via siteAdmin testNode.txt

awoods commented 5 years ago

@delsborg : Would you be interested in putting forward a pull-request?

delsborg commented 5 years ago

Hi Andrew, see the utf8mb4 branch. Also, it still doesn't work for uploads. See email I sent to tech group. This docker image does help to recreate the problem in a manner that anybody can reproduce :)

awoods commented 5 years ago

Reference: https://github.com/vivo-community/vivo-docker2/tree/utf8mb4

roflinn commented 5 years ago

@delsborg I added this into my PR for you if you didn't see: CREATE DATABASE vitrodb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;