UTF8 new installation
base on tutorial , i modified some files so i can use zc with UTF8 .
my database collation is set to UTF8_general_ci .
when i try to install zc , i get this error .
1406 Data too long for column 'configuration_value' at row 1
after searching, the forum , it turned out to be the currency characters in sql file. i removed it , and i pass that part of installation , until i hit with this error
1406 Data too long for column 'zone_name' at row 1
[INSERT INTO zones VALUES (80,81,'BAW','Baden Würtemberg');]
can not find additional info on zc sql file to make it work with UTF 8 .. was wondering any one can give a pointer .. thanks.
Re: UTF8 new installation
The problem seems to be with Mysql " sql mode "
my system sql mode set to STRICT_TRANS_TABLES , turning sql mode off , restarting mysql allows the installation .. i think this might be a bug in version 5.0.27 ..
By ckfs1 in forum Basic Configuration
Last Post: 8 Feb 2015, 05:28 AM
By Rick5150 in forum Upgrading from 1.3.x to 1.5.x
Last Post: 31 Dec 2013, 06:25 PM
By george_usa in forum Installing on a Linux/Unix Server
Last Post: 11 Jan 2011, 06:12 PM
By hugo13 in forum Bug Reports
Last Post: 8 Mar 2009, 02:28 PM
By 100asa in forum General Questions
Last Post: 14 Oct 2006, 07:34 PM
Content and Graphics Copyright (c) 2003 - 2017 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC