convert latin1 import to utf-8

tassoman · 2006-04-01 08:58:10

Hi all, I’m new of txp.
Reading forums i understood you suggest to use utf8 for db encoding (in config.php) and also in the meta tags.

Writing in utf-8 works for brand new articles, but if import a ready made latin1 (iso-8859-1) wordpress database, special chars are compromised.

My db is a 4.0 branch, i really dunno how to translate all rows from iso-8859-1 to utf-8. Some help?

Elenita · 2006-04-01 14:46:37

<blockquote>Reading forums i understood you suggest to use utf8 for db encoding</blockquote>

Meta tags should be encoded as UTF-8, but the database can be latin-1 without any problems. The encoding of the database itself doesn’t matter, so long as articles were entered as UTF-8 and the same doctype is used in page templates.

From <a href=“http://textpattern.net/wiki/index.php?title=Unicode_Support”>TextBook</a>:

<blockquote>MySQL 3.x or MySQL 4.0.x do not have Unicode-Support. The default character encoding is called latin1 and is single-byte, but this is less of a problem than it may seem. While the database itself is not aware of the actual encoding it still manages to output the articles and every other string in much the same way that they were previously put in the database.</blockquote>

If you’re still having trouble displaying special characters after changing your doctype, it’s probably a PHP issue. The TextBook article linked to above has more information, as does <a href=“http://textpattern.com/faq/40/non-ascii-characters-are-missing-or-incorrect”>this FAQ</a>.

And welcome to Textpattern, by the way.

Last edited by Elenita (2006-04-01 14:53:33)

tassoman · 2006-04-01 14:54:55

ok I’ve read textbook wich says mysql 4.0< users must use ‘latin1’ in config.php cause it’s the only understood by dbms.

Textpattern CMS

Textpattern CMS support forum

#1 2006-04-01 08:58:10

convert latin1 import to utf-8

#2 2006-04-01 14:46:37

Re: convert latin1 import to utf-8

#3 2006-04-01 14:54:55

Re: convert latin1 import to utf-8

Board footer