https://sourceforge.net/p/openemr/bugs/442/2016-07-06T08:09:06.684000ZRecent changes to 442: MariaDB installation problem2016-07-06T08:09:06.684000Z2016-07-06T08:09:06.684000ZBrady Millerhttps://sourceforge.net/u/bradymiller/https://sourceforge.netac6ad9432409ee0b767bf07b045ed0bdd2a8502e

<div class="markdown_content"><p>Hi,</p> <p>Agree that we should support UTF8MB4 (I am pretty sure UTF8 works for all languages including Chinese, but the extra bit in UTF8MB4 allows other characters such as emoticons etc.).</p> <p>We went through a similar process when converted from latin1 to UTF8 in OpenEMR 3.1.0 with some of the phpgacl table keys.</p> <p>-brady</p></div>

2016-07-05T14:57:33.668000Z2016-07-05T14:57:33.668000ZRod Roarkhttps://sourceforge.net/u/sunsetsystems/https://sourceforge.netb310b336f084508fe48a2318890e83df723e1a33

<div class="markdown_content"><p>Oh and I think it would be safe to make the selector much shorter, say 128 characters.</p></div>

2016-07-05T14:55:10.762000Z2016-07-05T14:55:10.762000ZRod Roarkhttps://sourceforge.net/u/sunsetsystems/https://sourceforge.net7c2c3261e83c3c6143b9e13e446ef8a8e73b93f9

<div class="markdown_content"><p>I understand utf8mb4 is desirable for supporting languages like Chinese, Japanese and Korean. Doubtless we should work towards that.</p></div>

2016-07-05T12:03:49.405000Z2016-07-05T12:03:49.405000ZOleg Sverdlovhttps://sourceforge.net/u/osverdlov/https://sourceforge.net7078d4b1685a5d4065f332202d78c7218172d822

<div class="markdown_content"><ul> <li>Description has changed:</li> </ul> <p>Diff:</p> <div class="codehilite"><pre><span class="gd">--- old</span> <span class="gi">+++ new</span> <span class="gu">@@ -1,7 +1,7 @@</span> <span class="gd">-On MariaDB issuing CREATE DATABASE openemr uses utf8mb4 character set by default. </span> <span class="gi">+On MariaDB if the database was created without specifying charset (i.e. issuing CREATE DATABASE openemr) then the DB will use utf8mb4 character set by default. </span> Initial install fails with the following message: unable to execute SQL: 'CREATE TABLE `drug_templates` ( `drug_id` int(11) NOT NULL, `selector` varchar(255) NOT NULL default '', `dosage` varchar(10) default NULL, `period` int(11) NOT NULL default '0', `quantity` int(11) NOT NULL default '0', `refills` int(11) NOT NULL default '0', `taxrates` varchar(255) default NULL, PRIMARY KEY (`drug_id`,`selector`)) ENGINE=InnoDB' due to: **Specified key was too long; max key length is 767 bytes** <span class="gd">-Need to use utf8 charset to create the database</span> <span class="gi">+Need to use utf8 charset to create the database, as automatic install does.</span> </pre></div> </div>

2016-07-05T12:02:29.355000Z2016-07-05T12:02:29.355000ZOleg Sverdlovhttps://sourceforge.net/u/osverdlov/https://sourceforge.net38340e1126fa9df9f60ec48c94edb6358b390d37

<div class="markdown_content"><p>Ticket 442 has been modified: MariaDB installation problem<br/> Edited By: Oleg Sverdlov (osverdlov)<br/> Description updated:<br/> --- description-old</p> <p>+++ description-new</p> <p>@@ -1,8 +1,8 @@</p> <p>-On MariaDB issuing CREATE DATABASE openemr uses utf8mb4 character set by default. <br/> +On MariaDB if the database was created without specifying charset (i.e. issuing CREATE DATABASE openemr) then the DB will use utf8mb4 character set by default. <br/> Initial install fails with the following message:</p> <p>unable to execute SQL: 'CREATE TABLE <code>drug_templates</code> ( <code>drug_id</code> int(11) NOT NULL, <code>selector</code> varchar(255) NOT NULL default '', <code>dosage</code> varchar(10) default NULL, <code>period</code> int(11) NOT NULL default '0', <code>quantity</code> int(11) NOT NULL default '0', <code>refills</code> int(11) NOT NULL default '0', <code>taxrates</code> varchar(255) default NULL, PRIMARY KEY (<code>drug_id</code>,<code>selector</code>)) ENGINE=InnoDB' due to: <strong>Specified key was too long; max key length is 767 bytes</strong></p> <p>-Need to use utf8 charset to create the database<br/> +Need to use utf8 charset to create the database, as automatic install does.</p></div>

2016-07-05T12:02:29.355000Z2016-07-05T12:02:29.355000ZOleg Sverdlovhttps://sourceforge.net/u/osverdlov/https://sourceforge.netbf4d1c7a0caefe1c2e47712c61bc78039827e766

<div class="markdown_content"><p>On MariaDB issuing CREATE DATABASE openemr uses utf8mb4 character set by default. <br/> Initial install fails with the following message:</p> <p>unable to execute SQL: 'CREATE TABLE <code>drug_templates</code> ( <code>drug_id</code> int(11) NOT NULL, <code>selector</code> varchar(255) NOT NULL default '', <code>dosage</code> varchar(10) default NULL, <code>period</code> int(11) NOT NULL default '0', <code>quantity</code> int(11) NOT NULL default '0', <code>refills</code> int(11) NOT NULL default '0', <code>taxrates</code> varchar(255) default NULL, PRIMARY KEY (<code>drug_id</code>,<code>selector</code>)) ENGINE=InnoDB' due to: <strong>Specified key was too long; max key length is 767 bytes</strong></p> <p>Need to use utf8 charset to create the database</p></div>