Hi,

When I want to sort by field, the data become weird characters (french accents : é î become é ÃŽ ...)

Any idea?

By the way, you've done a good work with this comp!

Thanks

Julie Portelance

Hi Julie,

thanks for your reply and nice words.

Can you check in phpMyAdmin if you have
MySQL encoding: UTF-8 Unicode (utf8)?

If you have then it's ok. Problem could be then if you are using some kind of DB editor that doesn't support UTF-8.

So, just try in phpMyAdmin to manually insert some french accents characters and see if it is ok.

I have tested this žšžßéî characters on my DB and it is ok.
(see in demo, Customers - record #92).

My settings in phpMyAdmin:
MySQL encoding: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci

Hope this could help.

Best regards,
Viljem

My DB is :

MySQL encoding: UTF-8 Unicode (utf8)
MySQL connection collation : utf8_general_ci

Can I change utf8_general_ci to utf8_unicode_ci without messing my data?

Thanks

Julie

well, I think that also utf8_general_ci should work. Can you look on particular tabel or view what is the rule for sorting? If it's utf8_general_ci then it is ok. Look this also on columns. You can loose data with switching this setting!

The difference is here between utf8_general_ci and utf8_unicode_ci:
forums.mysql.com/read.php?103,187048,188748#msg-188748

If this doesn't help, create new entry with these special characters in phpMyAdmin or just check your data in the table/view.

Regards,
Viljem

Thanks for your response.

But I think the problem is not in the database. Why?

All characters is database are OK.

When I load the page (link in my first post), all the characters / words are display correctly. In the page source too.

The problem is when I sorted the same page by "region" the characters / words are display with gibberish and the page source contain gibberish too.

I think the problem come from the Ajax processing.

BTW, I've change the encoding collation for the table wich contain data. The problem is not gone.

Can you shed some light on this please?

Thanks!

Hi Julie,

I was trying to reproduce your problem, but I couldn't. You might be right, that the problem is in ajax processing, but first I would ask you to test Table JX on another template, so that we can exclude everything else.

In general, to make encoding work well, everything must be in the same encoding (utf8 in Joomla). That means, database, database tables, columns and also all files on your server must be in utf8.

Regards,

Tomaž