<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Marco,<div class=""><br class=""></div><div class="">Interchange 5.6.3 had some support for UTF-8; you can try in your catalog.cfg:</div><div class=""><br class=""></div><div class="">DatabaseDefault MYSQL_ENABLE_UTF8 1</div><div class="">Variable MV_HTTP_CHARSET utf-8</div><div class=""><br class=""></div><div class="">There may be some other settings required here, but that’s what I recall from memory. Newer versions of IC improve on the UTF-8 support.</div><div class=""><br class=""></div><div class="">Best,</div><div class=""><br class=""></div><div class="">David<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Jan 17, 2018, at 10:59 AM, marco <<a href="mailto:m.mescoli@omnib.it" class="">m.mescoli@omnib.it</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">Debian GNU/Linux 9<br class="">Interchange V5.10.0<br class="">mysqld 10.1.26-MariaDB-0+deb9u1<br class=""><br class="">With italian accented characters mysql store and return wrong chars.<br class="">Try to change charater set to mysql scheme (all db) and table from latin1 to utf8, also put metatags on the input form page:<br class=""><meta http-equiv="content-type" content="text/html; charset=UTF-8" /><br class=""><br class="">but the only way i find to store and retrieve accented characters is this:<br class="">[query type=textref sql="SET NAMES UTF8"][/query]<br class="">before ANY update query.<br class=""><br class="">Is there a way to set global mysql UTF8 ?<br class=""><br class="">P.S.<br class="">In the previous version:<br class="">Debian GNU/Linux 6.0<br class="">Interchange V5.6.3<br class="">mysql 5.1.73<br class="">with the same catalogue and same database with latin1 charset all over i haven't this problem.<br class=""><br class="">Any suggestion ?<br class="">GREAT thanks.<br class="">Marco.<br class=""><br class="">-- <br class="">"Fino alla bara sinpara"<br class="">"Up to demise we rize"<br class=""><br class="">_______________________________________________<br class="">interchange-users mailing list<br class=""><a href="mailto:interchange-users@icdevgroup.org" class="">interchange-users@icdevgroup.org</a><br class="">http://www.icdevgroup.org/mailman/listinfo/interchange-users<br class=""></div></div></blockquote></div><br class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">--<br class="">David Christensen<br class="">End Point Corporation<br class=""><a href="mailto:david@endpoint.com" class="">david@endpoint.com</a><br class="">785-727-1171<br class=""><br class=""><br class=""></div>
</div>
<br class=""></div></body></html>