Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Location
    Montreal, Canada
    Posts
    2,285
    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,285
    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. search UTF8
    By hugo13 in forum Bug Reports
    Replies: 3
    Last Post: 8 Mar 2009, 02:28 PM
  2. UTF8 and Number
    By nnitin in forum Addon Language Packs
    Replies: 5
    Last Post: 24 Nov 2008, 01:14 PM
  3. UTF8 and ASCII PHP files Probles?
    By nnitin in forum Addon Language Packs
    Replies: 2
    Last Post: 24 Oct 2008, 12:47 AM
  4. made products_description table utf8 compatible?
    By soki in forum General Questions
    Replies: 2
    Last Post: 22 May 2008, 06:22 PM
  5. UTF8 problems with Advanced Search
    By saskvo4 in forum Addon Language Packs
    Replies: 8
    Last Post: 16 Jan 2008, 09:35 AM

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
  •