Jump to content

IPS charset problems after upgrade


Recommended Posts

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.

Link to comment
Share on other sites

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.


Link to comment
Share on other sites

  • 1 month later...

@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.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...