Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2006
    Posts
    24
    Plugin Contributions
    0

    Default Problem with size and maxlength after converting database to UTF8

    In order for the second language (bulgarian) to work correctly, I did the following changes in the my Zen Cart as described here: http://www.zen-cart.com/forum/showpo...59&postcount=5

    I converted my db to UTF8, as well as all collation of the tables and the fields from latin1 to utf8_general_ci with PhpMyAdmin

    Then I noticed that in the login/register page all the form fields have tripled their sizes and maxlengths, e.g. from 32 to 96. As I understand Zen cart asks the database for these values, but I could not find where they are stored in the db.

    My server info:
    Server OS: Linux 2.6.21.3-grsec
    Database: MySQL 5.0.41-log
    Server Date: 09/04/2007 13:12:38
    Database Date: 09/04/2007 13:12:38
    PHP Version: 4.4.7 (Zend: 1.3.0)
    HTTP Server: Apache

    I read the other threads about the maxlength=0 or =1 but I think that is not the case with me because I have a test Zen Cart shop running on the same server with latin1 collation database and it does not have this problem.

    URL to see the problem: https://www.diemfishing.com/catalog/...ain_page=login

  2. #2
    Join Date
    Oct 2006
    Posts
    24
    Plugin Contributions
    0

    Default Re: Problem with size and maxlength after converting database to UTF8

    Now I noticed that the the problem is not only with the login/register page but with all text fields in the catalog and the admin. Please help.

  3. #3
    Join Date
    Oct 2006
    Posts
    24
    Plugin Contributions
    0

    Default Re: Problem with size and maxlength after converting database to UTF8

    Ok, after a little investigation I found that when I restore /includes/classes/db/mysql/query_factory.php to the original the problem disappears.

    My query_factory.php is modified as described here: http://www.zen-cart.com/forum/showpo...59&postcount=5

  4. #4
    Join Date
    Oct 2006
    Posts
    24
    Plugin Contributions
    0

    Default Re: Problem with size and maxlength after converting database to UTF8

    After a little bit more investigation I found that zen_field_length function does not return correct values. Probably it is related to the database, particularly with the utf8 collation. Any suggestions how to resolve this problem?

    For now I set $length = $length/3

 

 

Similar Threads

  1. v151 Problem with passwords after converting customers from OSCommerce
    By DigiBooks in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 11 May 2014, 10:58 AM
  2. v150 2007 technique for converting a latin1 table to utf8
    By boxes in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 23 Jul 2012, 12:06 AM
  3. UTF8 and special characters after upgrade
    By aeolidia in forum Upgrading from 1.3.x to 1.3.9
    Replies: 6
    Last Post: 10 Apr 2011, 09:29 PM
  4. Problem with MySQL export with chinese and UTF8
    By gamenano in forum General Questions
    Replies: 0
    Last Post: 4 Nov 2010, 02:39 AM
  5. Replies: 2
    Last Post: 18 Dec 2006, 09:08 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