hello, can you please help me out, no matter what i try i keep running into error during install:
i have created my_db_charset.php in /includes/extra_configures & in /admin/includes/extra_configures with the line:
1366 Incorrect string value: '\xA3:&eur...' for column 'configuration_value' at row 1
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Convert currencies for Text emails', 'CURRENCIES_TRANSLATIONS', '£,£:€,€', 'What currency conversions do you need for Text emails?
Default = £,£:€,€', 12, 120, NULL, '2003-11-21 00:00:00', NULL, 'zen_cfg_textarea_small(');]
to no avail...
<?php define('DB_CHARSET', 'utf8');
The server specs:
<LI id=li_server_version>Server version: 5.1.44-community<LI id=li_mysql_proto>Protocol version: 10
<LI id=li_select_mysql_charset>MySQL charset: UTF-8 Unicode (utf8)
<LI id=li_web_server_software>Apache/2.2.15 (Win32) PHP/5.3.2<LI id=li_mysql_client_version>MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $<LI id=li_used_php_extension>PHP extension: mysql
The collation (not sure if it is related) is set to utf8_general_ci
This is a clean install on a new server and the default setting seems to be this utf8 setting. I am not the admin of this server and it isn't obvious to me where or how i could chang the character set to latin on the database itself.
The database is allready created for me, i can fill it with tables or drop the tables in it, but not alter the database itself.
Any input to resolve would be highly appreciated, thank you