<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Hi Mickaël,</div><div><br></div><div>I can see from your script that the database is created using UTF-8, but it could be the connection characterset that interprets the UTF-8 information as iso-8859-1. Force opening a UTF-8 text file with Närke using latin1 charset indeed render the text as Närke.</div><div><br></div><div>In the [mysqld] section of /etc/my.cnf, you can instruct the server to start with preferred characterset and collation:</div><div><br></div><div>character_set_server=utf8</div><div>default-character-set=utf8</div><div>character_set_client=utf8</div><div><div>collation_server=utf8_general_ci</div></div><div><div>skip-character-set-client-handshake</div></div><div><br></div><div>The last line force the connection charset as the one specified for the server.</div><div><br></div><div>So I suggest some steps:</div><div>1. Add lines above to your my.cnf</div><div>2. Restart the mysql,</div><div>3. First see if things still looks the same on TapirLink.</div><div>4. Try export the same sample script you gave us earlier, if the närke shows as it should be, then it should be fine on IPT.</div><div><br></div><div>Let me know if this setting works.</div><div><br></div><div>But if this change breaks TapirLink and others, you'll need to decide to configure others all or, see if Tim's suggestion works. (<span class="Apple-style-span" style="color: rgb(42, 0, 255); font-family: Monaco; font-size: 11px; ">jdbc</span><span class="Apple-style-span" style="color: rgb(42, 0, 255); font-family: Monaco; font-size: 11px; "><span style="color: rgb(0, 0, 0); ">:</span></span><span class="Apple-style-span" style="color: rgb(42, 0, 255); font-family: Monaco; font-size: 11px; "><a href="mysql://localhost:3306/specimen_collections?autoReconnect=true&useUnicode=true&characterEncoding=UTF8&characterSetResults=UTF8">mysql://localhost:3306/specimen_collections?autoReconnect=true&useUnicode=true&characterEncoding=UTF8&characterSetResults=UTF8</a>)</span></div><div><span class="Apple-style-span" style="color: rgb(42, 0, 255); font-family: Monaco; font-size: 11px; "><br></span></div><div>Cheers,</div><div><br></div><div>Burke</div></body></html>