topic Re: Altering Database/Tables for utf8mb4 in Alfresco Archive

Altering Database/Tables for utf8mb4

travis_wilson — Mon, 08 Aug 2016 22:37:02 GMT

Hello,I'm looking to alter activiti to use utf8mb4 instead of utf8_bin. When running the following sql command:<sql>ALTER TABLE `activiti`.'ACT_RE_PROCDEF' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;<sql>I get the following error: Error Code 1071. Specified key was to long; max

Re: Altering Database/Tables for utf8mb4

trademak — Wed, 10 Aug 2016 08:09:41 GMT

Hi,

It probably means that some of the varchar columns we are using should have less characters, like the RESOURCE_NAME_ column with varchar(4000). We don't have it on the roadmap yet, but if there's a lot of interest in it in the community we can add it.

Best regards,

Re: Altering Database/Tables for utf8mb4

travis_wilson — Wed, 07 Sep 2016 14:34:14 GMT

Hello,

I was able to fix the issue with the keys not being able to be upgrade by changing from:

SET innodb_large_prefix=ON;
to
SET GLOBAL innodb_large_prefix=ON;

Once I made these changes I was able to manually insert emoji characters into the database using MySQLWorkbench but ran into an issue when I tried to follow the publish process via java code. The issue occurs when trying to parse the data into xml. JDK 1.8 has an issue that cause the emojis to throw a xml parse issue. Here is a link to the exact error / location of the issue in stackoverflow:

http://stackoverflow.com/questions/31867818/java-xml-parser-with-emoji-character

I hope this helps anyone else who might be trying to do this. Have a great one!