<?xml version='1.0' encoding='UTF-8'?>
<rss version='2.0'>
	<channel>
		<title>cotonti.com : Unable to convert sql to UTF8</title>
		<link>https://www.cotonti.com</link>
		<description>Last topic posts</description>
		<generator>Cotonti</generator>
		<language>en</language>
		<pubDate>Sat, 11 Apr 2026 22:51:55 -0000</pubDate>

		<item>
			<title>Lombi</title>
			<description><![CDATA[Lol i tried replying to your first set of problems but you edited them out already.<br />
<br />
I would suggest removing all your custom index plugins and then readding them to see where the issue lies. I'm pretty sure it's in one of them (that used a setting in config.php or something in that nature)<br />
<br />
-- <br />
<br />
as for the import bit, please doublecheck that you have set utf8 inside of bigdump (it defaults to latin1)]]></description>
			<pubDate>Sat, 04 Apr 2009 16:24:51 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/forums?m=posts&q=2535&d=0#post11019]]></link>
		</item>
		<item>
			<title>musiconly</title>
			<description><![CDATA[I uploaded the database you converted with bigdump and characters aren't showing properly.. there are also some missing tables which i had to create manually in phpmyadmin.. and also an error on the index which i don't get..<br />
<br />
<br />
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/***/public_html/system/database.mysql.php on line 209<br />
<br />
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/**/public_html/system/database.mysql.php on line 97]]></description>
			<pubDate>Sat, 04 Apr 2009 05:51:52 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/forums?m=posts&q=2535&d=0#post11001]]></link>
		</item>
		<item>
			<title>Lombi</title>
			<description><![CDATA[I dont understand. I encoded your database myself (even used yours in the video tutorial) and uploaded it to your ftp account. Did you import it via bigdump with an incorrect character set?]]></description>
			<pubDate>Fri, 03 Apr 2009 17:07:21 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/forums?m=posts&q=2535&d=0#post10944]]></link>
		</item>
		<item>
			<title>musiconly</title>
			<description><![CDATA[I'm trying to convert sql database to UTF8 but with no success!<br />
<br />
I'm doing it by following Lombi's great video lessons but somehow I can't fix those problematic characters. My database has been used for recording this video lesson : <a href="http://www.cotonti.com/docs/en/upgradevideos/fixing_problematic_utf8_dumps">http://www.cotonti.com/docs/en/upgradevideos/fixing_problematic_utf8_dumps</a><br />
<br />
but even though i follow it step by step I can't get characters right.<br />
<br />
I'm using Notepad++ 5.3.1. I have splited 130mb sql file into several files making sure that they don't exceed the limit of 30MB.<br />
<br />
When I choose Encode to UFT8 without BOM i get C4? instead of SOME characters (č) and the rest is the same - no ž,š...<br />
<br />
I even tried encoding to UTF8 but no luck!<br />
<br />
What's the problem?<br />
<br />
Thanks!]]></description>
			<pubDate>Fri, 03 Apr 2009 07:33:04 -0000</pubDate>
			<link><![CDATA[https://www.cotonti.com/forums?m=posts&q=2535&d=0#post10938]]></link>
		</item>
	</channel>
</rss>