IPS charset problems after upgrade

[PokemonMillennium]

I've just upgraded my IPS installer to 4.0. I've converted tables in UTF-8 (not UTF-8 mb4) with DB converter script. After upgrade, all special characters (like é, è, ecc.) aren't showed correctly on board (es. "é" shows "é"). Is there a way to correct them? Maybe I can update charset of database and tables with a custom script?

Thanks and sorry for my English.

[ramon.cutanda]

Same problem here :-(

[mac Spaulding]

ipboard support did my upgrade and same thing happened and they rolled me back said the devs are working on a fix been 2 days now so must be a tricky one lol

[ramon.cutanda]

I have run the following mysql command to check variables:

show variables like "%character%";show variables like "%collation%";

This is the result:

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0,00 sec)

+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | utf8_general_ci   |
| collation_database   | latin1_swedish_ci |
| collation_server     | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0,00 sec)

So, in my case, I have mixed collations; both utf8 and latin1. I guess that is the problem in my case.

In IPB 3.x everything showed up correctly using this variable in conf_global.php

$INFO['sql_charset']			=	'latin1';

But it does not seem to work any more.

I will try to learn more about this issue.

Bests,

[genrobgen]

@ramon.cutanda did you ever solve this problem?

I have something similar. After the upgrade from IPS3 to IPS4 all posts and titles are messed up if they previously contained accented characters.

In my case the posts and titles are trunctated at the point where the accented character was positioned. The accented character and everything after it is deleted from the database.

[ramon.cutanda]

Nop... In the end, I simply gave up and I will stick to SMF for the time being.

 

Sorry for not being able to provide any more help.

 

Bests,