Hello,
I have a problem with a ZEN cart site of one of our customers.
After migrating it to our servers, some characters (like the €-sign) are corrupted.
I think it's a mismatch in the character set, but I'm not sure on how to fix this.
For example when I create a coupon code with a €-sign in the couponcode field, I get a SQL error.
The customer states this worked at the previous server.
This is the error thrown (this is an update, but a create ends in the same error).
1366 Incorrect string value: '\x8050' for column 'coupon_code' at row 1
in:
[update coupons set coupon_code = '€50', coupon_amount = '10.0000', coupon_type = 'P', uses_per_coupon = '0', uses_per_user = '1', coupon_minimum_order = '0', restrict_to_products = '', restrict_to_categories = '', coupon_start_date = '2014-11-06', coupon_expire_date = '2015-11-06', date_created = now(), date_modified = now(), coupon_zone_restriction = '0' where coupon_id='12']
Bookmarks