Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Location
    Montreal, Canada
    Posts
    2,282
    Plugin Contributions
    0

    Default UTF8 new installation

    Hello.
    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
    in:
    [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.

  2. #2
    Join Date
    Jul 2006
    Location
    Montreal, Canada
    Posts
    2,282
    Plugin Contributions
    0

    Default Re: UTF8 new installation

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

 

 

Similar Threads

  1. Replies: 2
    Last Post: 8 Feb 2015, 05:28 AM
  2. v151 UTF8 Conversion
    By Rick5150 in forum Upgrading from 1.3.x to 1.5.x
    Replies: 1
    Last Post: 31 Dec 2013, 06:25 PM
  3. v1.3.9h utf8 new installation right sidebox and bottom footer missing
    By george_usa in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 11 Jan 2011, 06:12 PM
  4. search UTF8
    By hugo13 in forum Bug Reports
    Replies: 3
    Last Post: 8 Mar 2009, 02:28 PM
  5. new installation and new order id
    By 100asa in forum General Questions
    Replies: 5
    Last Post: 14 Oct 2006, 07:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR