Textpattern CMS

#1 2006-10-03 07:30:33

mikkeX

Archived Plugin Author

Registered: 2004-02-26

Posts: 74

from utf8 to latin1

I used had to move a textpattern site from a webhotel that had mysql 4.1 to another with 4.0, and now I have problem with the char-encoding. All åäö etc comes out as ? and other stuff.

So is there an solution to this. I tried to change the encoding in config.php from utf-8 to latin1 but that does not do the trick.

My diagnostics looks like this:

Textpattern-version: 4.0.3 (r1188)
last_update: 2006-02-13 18:54:20/2006-10-03 06:15:37
Dokument-rot: /home/kultsvse/webbhotell_html (/mnt/sdc4/home/kultsvse/webbhotell_html)
$path_to_site: /mnt/sdc4/home/fmedia/public_html
Textpattern-s�kv�g: /mnt/sdc4/home/fmedia/public_html/textpattern
Permanentl�nk-l�ge: id_title
Tillf�llig mapp: /mnt/sdc4/home/fmedia/public_html/textpattern/tmp
Sajt-URL: webhotell3.kserv.se/friamedia
PHP-version: 4.4.0
server_time: 2006-10-03 09:26:25
MySQL: 4.0.25
Locale: sv_SE.ISO_8859-1
Server: Apache/2.0.52 (Gentoo/Linux) auth_external/2.2.1 mod_ssl/2.0.52 OpenSSL/0.9.7i PHP/4.4.0
Apache-version: Apache/2.0.52 (Gentoo/Linux) auth_external/2.2.1 mod_ssl/2.0.52 OpenSSL/0.9.7i PHP/4.4.0
php_sapi_mode: apache2handler
os_version: Linux 2.6.11-gentoo-r9

Inneh�ll i .htaccess-filen:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/

<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]

RewriteRule ^(.*) index.php </IfModule>

php_value register_globals 0
#php_flag register_globals off
————————————

Last edited by mikkeX (2006-10-03 07:31:10)

#2 2006-10-03 09:52:54

wet

Developer Emeritus

From: Vöcklabruck, Austria

Registered: 2005-06-06

Posts: 3,391

Website GitHub Mastodon

Re: from utf8 to latin1

At a similar occasion I succeeded by setting the import charset in phpMyAdmin to ‘utf-8’ while keeping the charset setting in config.php at “latin1”. My conclusion: It largely depends on the settings during import.

#3 2006-10-03 15:22:57

mikkeX

Archived Plugin Author

Registered: 2004-02-26

Posts: 74

Re: from utf8 to latin1

How do you set the import charset in PhpMyAdmin?

#4 2006-10-03 22:24:02

mikkeX

Archived Plugin Author

Registered: 2004-02-26

Posts: 74

Re: from utf8 to latin1

Okay, problem solved, took a while to I understodd…

I set the gui-charset for phpmyadmin to an utf-8 version and imported my database, which were utf-8 encoded and had latin1 in config.

Thanks for the help.