<div dir="ltr">If I have time to tackle the issue, I'll try and share the changes.<div>Cheers,</div><div><br></div><div>jmm<br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div>--</div><div><div>José Manuel Martínez Martínez</div><div><a href="https://chozelinek.github.io" target="_blank">https://chozelinek.github.io</a></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Wed, Aug 29, 2018 at 8:54 AM José Manuel Martínez Martínez <<a href="mailto:chozelinek@gmail.com">chozelinek@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hi Andrew,<div><br></div><div>thanks for your answer. I've modified the `db.inc.php` like this:</div><div><br></div><div>This is the diff of my modifications:</div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">Index: lib/db.inc.php</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">===================================================================</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">--- lib/db.inc.php<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>(revision 1057)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+++ lib/db.inc.php<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>(working copy)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">@@ -401,7 +401,7 @@</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>primary key(refnumber),</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>key(text_id) $extra_sql_keys</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE utf8_bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>/* </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> * note the use of a binary collation for distribution DBs, since</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> * they always contain handle IDs, not word or tag material.</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">@@ -478,7 +478,7 @@</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>`$att` varchar(40) NOT NULL";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>$create_statement .= ",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>key (refnumber)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE {$Corpus->sql_collation}";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8mb4 COLLATE {$Corpus->sql_collation}";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>break;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"> </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">@@ -533,7 +533,7 @@</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>endPosition int unsigned NOT NULL,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>refnumber mediumint unsigned NOT NULL AUTO_INCREMENT,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>primary key(refnumber)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE {$Corpus->sql_collation}";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8mb4 COLLATE {$Corpus->sql_collation}";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"> </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>break;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"> </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">@@ -551,7 +551,7 @@</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>category varchar(40),</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>primary key(refnumber),</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>key(category)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE {$Corpus->sql_collation}";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8mb4 COLLATE {$Corpus->sql_collation}";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>break;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"> </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">Index: lib/freqtable.inc.php</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">===================================================================</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">--- lib/freqtable.inc.php<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>(revision 1057)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+++ lib/freqtable.inc.php<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>(working copy)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">@@ -192,7 +192,7 @@</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>global $Config;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>global $Corpus;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>global $User;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span></span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>php_execute_time_unlimit();</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>global $cqp;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"> </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>if (empty($cqp))</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">Index: lib/indexforms-queries.inc.php</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">===================================================================</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">--- lib/indexforms-queries.inc.php<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>(revision 1057)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+++ lib/indexforms-queries.inc.php<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>(working copy)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">@@ -74,7 +74,7 @@</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'sq_case' => 'Simple query (case-sensitive)',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>);</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>if (! array_key_exists($qmode, $modemap) )</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">-<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>$qmode = ($Corpus->uses_case_sensitivity ? 'sq_case' : 'sq_nocase');</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+<span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>$qmode = ($Corpus->uses_case_sensitivity ? 'sq_case' : 'cqp');</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>/* includes NULL, empty */</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"> <span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span></span></p></div><div><br></div><div>But I'm getting this error when I try to run collocations:</div><table class="m_-1704938725558711864gmail-concordtable" width="100%" style="color:rgb(0,0,0);border:5px solid rgb(255,255,255);font-family:Times"><tbody><tr><td class="m_-1704938725558711864gmail-concorderror" style="padding:3px 7px;background-color:rgb(255,238,170);font-family:verdana;font-size:10pt;border:2px solid rgb(255,255,255)"><p class="m_-1704938725558711864errormessage" style="font-size:large">A MySQL query did not run successfully!</p><p> </p></td></tr><tr><td class="m_-1704938725558711864gmail-concorderror" style="padding:3px 7px;background-color:rgb(255,238,170);font-family:verdana;font-size:10pt;border:2px solid rgb(255,255,255)"><p> </p><p class="m_-1704938725558711864errormessage" style="font-size:large">Error # 1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'</p></td></tr></tbody></table><div><div><div dir="ltr" class="m_-1704938725558711864gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><br></div><div>I guess that I need to touch the code in more places, and probably do that on a test environment (I put the change in production ;-)</div><div><br></div><div>With this command <span style="color:rgb(0,0,0);font-family:Menlo;font-size:11px">grep -rn . -e 'utf8_' </span> I get this list of files that seems to contain mentions to UTF8:</div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">104</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures">$Config->mysql_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">set_required = (isset($mysql_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">set_required) && $mysql_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">set_required);</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">225</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) ENGINE=InnoDB CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">231</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) ENGINE=InnoDB CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">265</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>(`corpus` varchar(20) NOT NULL,`target` varchar(20) NOT NULL) ENGINE=InnoDB CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">313</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"> ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">382</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) ENGINE=InnoDB CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin"</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">401</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"> ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">411</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"> ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin'</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">665</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin'</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">690</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">698</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">739</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `annotation_metadata` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">740</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `annotation_template_info` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">741</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `annotation_template_content` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">742</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `corpus_metadata_variable` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">743</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `saved_dbs` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">744</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `saved_freqtables` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">745</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `saved_subcorpora` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">746</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `user_memberships` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">747</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `user_privilege_info` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">748</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `query_history` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">749</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `system_processes` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">750</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `text_metadata_fields` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">751</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `text_metadata_values` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">752</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `user_info` collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">753</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>/* using </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin for user_info implies the following for specific columnss: */</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">754</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `user_info` modify column `affiliation` varchar(255) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci default NULL',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">755</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `user_info` modify column `email` varchar(255) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci default NULL',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">756</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table `user_info` modify column `realname` varchar(255) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci default NULL',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">780</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">789</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">794</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">802</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">884</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"> ) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">891</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"> ) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin"</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">953</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>'alter table user_info modify column `username` varchar(30) charset utf8 collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin NOT NULL',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">959</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> ) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">968</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">973</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci'</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">1085</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> setting_name varchar(20) NOT NULL collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">1088</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> ) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">1100</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> `group_name` varchar(20) NOT NULL UNIQUE COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">1104</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> ) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">1107</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">1170</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">1181</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">1184</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/upgrade-database.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">1187</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci",</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./bin/autosetup.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">69</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures">$Config->mysql_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">set_required = $mysql_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">set_required;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/admin-lib.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">478</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARSET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin ");</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/concordance-post.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">601</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>$extra_sort_pos_sql .= ", before$i COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci ";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/concordance-post.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">607</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>$extra_sort_pos_sql = ", after1 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci"</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/concordance-post.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">608</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>. ", after2 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci"</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/concordance-post.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">609</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>. ", after3 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci"</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/concordance-post.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">610</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>. ", after4 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci"</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/concordance-post.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">611</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>. ", after5 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/concordance-post.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">617</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>$extra_sort_pos_sql .= ", after$i COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/concordance-post.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">649</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>ORDER BY $sort_position_sql COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci $extra_sort_pos_sql ";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/concordance-post.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">651</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> * we always use </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci for the actual sorting,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/concordance-post.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">652</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> * even if the collation of the sort DB is actually </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/db.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">278</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>$</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">filename = $tabfile .'.utf8.tmp';</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/db.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">281</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> $</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">filename, </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/db.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">286</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>rename($</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">filename, $tabfile);</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/library.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">180</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>if ($Config->mysql_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">set_required)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/library.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">549</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>return $corpus_info->uses_case_sensitivity ? '</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin' : '</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci' ;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/defaults.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">80</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>METADATA_TYPE_CLASSIFICATION => 'varchar(255) default NULL COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/defaults.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">81</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>METADATA_TYPE_FREETEXT => 'text default NULL COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/defaults.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">82</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>METADATA_TYPE_IDLINK => 'varchar(255) default NULL COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/defaults.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">83</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>METADATA_TYPE_UNIQUE_ID => 'varchar(255) default NULL COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin',</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/defaults.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">84</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>METADATA_TYPE_DATE => 'varchar(255) default NULL COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin', </span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/defaults.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">224</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures">if (!isset($mysql_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">set_required))</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/defaults.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">225</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>$mysql_</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">set_required = true;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">154</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">166</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">175</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">187</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">200</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">209</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">216</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">225</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">307</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">316</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">327</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">340</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">349</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">359</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">376</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">389</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">410</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">424</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">437</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">447</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">474</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine_if_fulltext_key_needed CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">489</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">503</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">508</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>setting_name varchar(20) NOT NULL collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">511</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">general_ci"; /* note that for this one we don't care about the engine */</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">520</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>) $engine CHARACTER SET utf8 COLLATE </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin";</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)">528</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures"><span class="m_-1704938725558711864gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>`content` text character set utf8 collate </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(195,55,32)"><b>utf8_</b></span><span style="font-variant-ligatures:no-common-ligatures">bin,</span></p>
<p style="margin:0px;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(213,59,211)">./lib/sql-definitions.inc.php</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(51,187,200)">:</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(52,188,38)"></span></p></div></div></div></div></div></div></div></div></div></div></div></div></blockquote></div>