<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font size="-1"><font face="Tahoma">Hi,<br>
We have solved the problem with utf8mb4_unicode_ci collation.<br>
No issue have been detected since this update.<br>
<br>
Regards,<br>
Boris Clement<br>
<a class="moz-txt-link-freetext" href="http://www.abo-s.com/">http://www.abo-s.com/</a><br>
</font></font><br>
<div class="moz-cite-prefix">Le 30/07/2018 à 12:37, Martin Allen a
écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CAL1vgxGjku2+w7-DktRiAOr64GZqq_QfGJ53+Diz=Mwwqjxz9Q@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div dir="ltr">
<div class="gmail_default"
style="font-family:verdana,sans-serif">We are seeing multiple
issues with Emails and Comments not supporting Emojis as the
mySQL Database only uses utf8 instead of utf8_mb4.</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
Is the solution as simple as updating the affected
tables/columns to utf8_mb4?<br>
Are there any other issues we might encounter by doing this? <br>
Has anyone done this before?</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default"
style="font-family:verdana,sans-serif">Thanks!</div>
<div><br>
</div>
-- <br>
<div class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<p style="font-size:12.8px;color:rgb(80,0,80)"><span
style="color:navy;font-family:Verdana,sans-serif;font-size:10pt">Martin
Allen</span></p>
<p style="font-size:12.8px;color:rgb(80,0,80)"><b
style="color:rgb(34,34,34);font-size:12.8px"><span
style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"
lang="EN-US"><a
href="https://emailrtc.voiceflex.com/?c=7b355216c4"
style="color:rgb(17,85,204)" target="_blank"
moz-do-not-send="true"><span
style="color:rgb(31,73,125)">>>Call me
now for free<<</span></a></span></b><span
style="color:navy;font-family:Verdana,sans-serif;font-size:10pt"><br>
</span></p>
<p style="font-size:12.8px;color:rgb(80,0,80)"><b
style="font-size:12.8px"><span
style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(51,51,153)"
lang="EN-US">01392 248692 - Main Office<br>
01392 690659 - Direct Line</span></b><br>
</p>
<p style="font-size:12.8px;color:rgb(80,0,80)"><b><span
style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(51,51,153)"><img
src="cid:part2.E491F1E2.BE4636A3@abo-s.com"
alt="signature2" class="" height="65"
width="288"></span></b><span
style="color:rgb(31,73,125)"></span></p>
<p style="font-size:12.8px;color:rgb(80,0,80)"><span
style="font-size:10pt;font-family:Verdana,sans-serif;color:navy"
lang="EN-US">Have you visited our website recently? <a
href="http://www.clystnet.com/"
style="color:rgb(17,85,204)" target="_blank"
moz-do-not-send="true">http://www.clystnet.com</a></span><span
style="color:rgb(31,73,125)"></span></p>
<p style="font-size:12.8px;color:rgb(80,0,80)"><span
style="font-size:10pt;font-family:Verdana,sans-serif;color:navy"
lang="EN-US"><br>
</span><span
style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(153,153,153)"
lang="EN-US">The information in this email is
confidential If you are not the intended recipient,
you must not read or use that information. This
email and any attachments are believed to be virus
free however no responsibility is accepted by
Clystnet for any loss or damage arising in any way
from receipt or use thereof. Clystnet Ltd (company
reg number 7164503) is based at Silverdown Park,
Fair Oak Close, Clyst Honiton, EX5 2UX</span></p>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
</body>
</html>