Textpattern CMS

#1 2007-11-09 15:08:02

vanderkerkoff

Member

Registered: 2005-05-26

Posts: 45

upgrade to 4.0.5 problem with character set

hello everyone

we’ve upgraded to 4.0.5 from 4.0.2 and all of a sudden pound signs and other odd characters are all over the place, not showing the correct symbol

Anyone got any ideas why?

I can see that there’s a new line in config.php about database charset, is that relevant?

Any help, greatly appreciated

#2 2007-11-09 15:13:50

vanderkerkoff

Member

Registered: 2005-05-26

Posts: 45

Re: upgrade to 4.0.5 problem with character set

In the high diagnostics output theres this bit
Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/local/mysql-standard-4.1.14-pc-linux-gnu-i686-glibc23/share/mysql/charsets/
18 Tables: OK

Is it because the server is latin1 but the system is utf8 that we’re having the problem?

Need some help quickly fellas if anyone is listening.

#3 2007-11-09 15:22:27

vanderkerkoff

Member

Registered: 2005-05-26

Posts: 45

Re: upgrade to 4.0.5 problem with character set

If I put the old 4.0.2 folder back in place, then it’s fine, all characters are good. The high level output for that is

Charset (default/config): latin1/
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_results: latin1
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/local/mysql-standard-4.1.14-pc-linux-gnu-i686-glibc23/share/mysql/charsets/
18 Tables: textpattern is utf8, txp_category is utf8, txp_css is utf8, txp_discuss is utf8, txp_discuss_ipban is utf8, txp_discuss_nonce is utf8, txp_file is utf8, txp_form is utf8, txp_image is utf8, txp_lang is utf8, txp_link is utf8, txp_log is utf8, txp_page is utf8, txp_plugin is utf8, txp_prefs is utf8, txp_priv is utf8, txp_section is utf8, txp_users is utf8

Any tips fellas?

#4 2007-11-09 16:05:56

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: upgrade to 4.0.5 problem with character set

Perhaps a strange sounding advice, but in your config.php in TXP 4.0.5, change the characterset to latin1.

#5 2007-11-13 11:23:30

vanderkerkoff

Member

Registered: 2005-05-26

Posts: 45

Re: upgrade to 4.0.5 problem with character set

Hi Ruud

Thanks for getting back mate, yep, that did the trick, characters all good now.

Thanks