Re: [xwiki-users] 4-byte UTF and XWiki (MySQL utf8mb4 encoding)

Some more information: On my Mac, when I try to set up XWiki with MySQL, I ran the following: # Install mysql and start brew update brew install mysql mysql.server start # Now I can connect as "mysql -uroot" # Create a new MySQL database for XWiki # see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL mysql -u root -e "create database xwiki default character set utf8mb4 collate utf8mb4_unicode_ci" mysql -u root -e "grant all privileges on *.* to xwiki@localhost identified by 'xwiki'" # Configure hibernate.cfg.xml # This is only the mysql section <property name="connection.url">jdbc:mysql://localhost/xwiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="connection.useUnicode">true</property> <property name="connection.characterEncoding">UTF-8</property> <property name="dbcp.poolPreparedStatements">true</property> <property name="dbcp.maxOpenPreparedStatements">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/> Now when I start XWiki, I get the error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs It looks like whatever creates the XWiki tables is not handling utf8mb4 (see also https://mathiasbynens.be/notes/mysql-utf8mb4 ). On Wed, Apr 6, 2016 at 5:17 PM, Debajit Adhikary &lt;debajit.work(a)gmail.com&gt; wrote: