Sending text to mySQL storage cuts off at special characters

[thoberre]

Hi,

I've installed Zen-Cart 1.3.7 with norwegian translation on a Gentoo box.

When I start adding products I consistently get cut off text at special characters (æøå, accented characters etc). The preview shows the text correct, but when it's about to save to mySQL database it gets cut off at the first special character encountered.

I'm suspecting CHARSET/Collation issues, but unfortunately I'm too newbie to know where to start to correct this behavior.

I have:

Zen Cart 1.3.7.1
Database Patch Level: 1.3.7.1

PHP Version 5.2.4_p20070914-pl2-gentoo

Database: MySQL 5.0.38

HTTP Response Headers : Content-Type text/html; charset=iso-8859-1

mySQL db: `zencart` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

php.ini : mysql.connect_charset = utf8

zen-cart: includes/languages/norwegian.php
// charset for web pages and emails
define('CHARSET', 'iso-8859-1');
header('Content-Type: text/html; charset=' . CHARSET);


Could someone please point me in the right direction?