All fields including Tv's are not exepting special characters

When i use a ü in a tv or any other field, then everything that is following that character including the ü is removed from the tv, I tried making a plugin that replaces the characters but it looks like there is no plugin event that I can use to do a simple thing as this:

$_POST[’tv36’] = htmlentities($_POST[’tv36’]);

in version pre 1.0.0 This was not a problem than I could use those characters without the problem that the field is stripped.

this is a big problem for we use a lot of charachters like that.


Dimmy

This works perfectly for me on a default 1.0.2 install using UTF-8 charset on the MODx side and utf8_general_ci collation on the database tables. More information on your database/table character sets/collations and the MODx charset setting is needed. Also, include what your database_connection_charset variable is.

Ok these are my settings:


MySQL - 5.0.46
Apache/2.0.52 (CentOS)
PHP Version 5.2.9
MySQL character set: "UTF-8 Unicode (utf8)"
ModX character set: "Unicode (UTF-8) - utf-8"
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7

where do I find the database_connection_charset variable?

On the same server and databaseserver I have already running 150+ modx websites that work without a problem

Quote from: Dimmy at Nov 24, 2009, 04:09 AM

MySQL - 5.0.46
Apache/2.0.52 (CentOS)
PHP Version 5.2.9
MySQL character set: "UTF-8 Unicode (utf8)"
ModX character set: "Unicode (UTF-8) - utf-8"
HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7

where do I find the database_connection_charset variable?

In the config file (you set this at install time); you’ll need to see the collation of the database container, and check the tables/fields to make sure those match the database container. The MySQL server character set doesn’t really mean anything, unless that is the MySQL client connection character set you reported...

$database_connection_charset = ’utf8’;
$database_connection_method = ’SET CHARACTER SET’;

Quote from: Dimmy at Nov 24, 2009, 09:41 AM

$database_connection_charset = ’utf8’;
$database_connection_method = ’SET CHARACTER SET’;

And did you confirm both the database and the tables in it have a utf8 collation?

yes it is:

utf8_general_ci

I cannot reproduce this problem at all. Something is definitely not utf8. Are you sure the manager language you are using is UTF-8?

I can give you a test account if you like?

it also happens when I save a chunk with a ’in it