Hello, my problem is that I made a migration from version 4, and I have many problems with special characters like accents and others.
The language is Spanish and can see an example in the following url
http://www.foroz.org/foroz/forum/inf...able-en-google
But the forum if it is, though not so messages
http://www.foroz.org/foroz/forum/inf...s-informáticos
I have read a lot of documentation and tested in different ways using utf html and activating the config file line
$config['Mysqli']['charset'] = 'utf8';
With this last line forum stops working completely
Later I followed instructions in the documentation by running a query:
SHOW VARIABLES LIKE 'char%'
and the result is:
as you can see the problem should be there, to have different character code to perform the steps to solve this by creating the file and indicating in the config file the line:
$config['Mysqli']['ini_file'] = realpath('./../../mysqli.ini');
$config['Mysqli']['ini_file'] = '/httpdocs/foroz/mysqli.ini';
or
$config['Mysqli']['ini_file'] = 'mysqli.ini';
but did not work, the problem must be in the difference in coding? I hope can help me since my system is throwing errors and many issues are not accessible right now
sorry for my English ...
The language is Spanish and can see an example in the following url
http://www.foroz.org/foroz/forum/inf...able-en-google
But the forum if it is, though not so messages
http://www.foroz.org/foroz/forum/inf...s-informáticos
I have read a lot of documentation and tested in different ways using utf html and activating the config file line
$config['Mysqli']['charset'] = 'utf8';
With this last line forum stops working completely
Later I followed instructions in the documentation by running a query:
SHOW VARIABLES LIKE 'char%'
and the result is:
character_set_client | latin1 |
character_set_connection | latin1 |
character_set_database | utf8 |
character_set_filesystem | binary |
character_set_results | latin1 |
character_set_server | latin1 |
character_set_system | utf8 |
character_sets_dir | /usr/share/mysql/charsets/ |
$config['Mysqli']['ini_file'] = realpath('./../../mysqli.ini');
$config['Mysqli']['ini_file'] = '/httpdocs/foroz/mysqli.ini';
or
$config['Mysqli']['ini_file'] = 'mysqli.ini';
but did not work, the problem must be in the difference in coding? I hope can help me since my system is throwing errors and many issues are not accessible right now
sorry for my English ...
Comment