Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 36
  1. #21
    Join Date
    Mar 2011
    Posts
    3
    Plugin Contributions
    0

    red flag Re: ability to define DB_CHARSET ?

    i use version 1.3.9.. i added my_db_charset.php in admin/includes/extra configures/ and another location

    after , in admin panel i used save or update button opening blank page..

    please help me!

    thanks..

  2. #22
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    214

    Default Re: ability to define DB_CHARSET ?

    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #23
    Join Date
    Aug 2004
    Location
    Osaka Japan
    Posts
    163
    Plugin Contributions
    0

    Default Re: ability to define DB_CHARSET ?

    Quote Originally Posted by power35 View Post
    i use version 1.3.9.. i added my_db_charset.php in admin/includes/extra configures/ and another location

    after , in admin panel i used save or update button opening blank page..

    please help me!

    thanks..
    I had simular problem where adding my_db_charset.php to both admin and store /includes/extra_configures/ folders resulted in blank pages. The error was making the statement <?php two times in the file (listed below) a simple editing error.

    <?php
    /**
    * File defines the charcter set of the database
    * Put in store/includes/extra-configures/my_db_charset.php and
    * admin/indludes/extra-configures/my_db_charset.php
    *
    * @copyright Copyright 2003-2007 Zen Cart Development Team
    * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
    */
    /**
    */
    <?php define('DB_CHARSET', 'utf8');
    ?>

  4. #24
    Join Date
    Mar 2011
    Posts
    76
    Plugin Contributions
    0

    Default Re: ability to define DB_CHARSET ?

    Quote Originally Posted by DrByte View Post
    Create a new file for it:

    /includes/extra_configures/my_db_charset.php
    Code:
    <?php define('DB_CHARSET', 'your_charset_here');
    Do the same with: /admin/includes/extra_configures/my_db_charset.php
    when should i add this file to extra_configures folder?
    all tables have been installed in database, the collation is latin1_general_ci, is it too late to add this file? cause the database tables remain latin1_general_ci

    perhaps i should change all ENGINE=MyISAM to ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci before i install the cart ?

    what do i change all latin1_general_ci to utf8_general_ci now ?

  5. #25
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    214

    Default Re: ability to define DB_CHARSET ?

    Don't go mucking with existing database content. You can't just randomly change charsets on a whim. To do that requires careful alteration of all your existing data, and is an advanced operation you shouldn't be attempting without advanced knowledge of the topic.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  6. #26
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,033
    Plugin Contributions
    32

    Default Re: ability to define DB_CHARSET ?

    Wanna thank everyone for this very helpful post. Between this post, the Numinix instructions (which appears to be a basic summary of the information in this thread), and and Dr Byte's cool tool, I got this done in fairly short order.. Of course the store I converted is a dev store with minimal data in it..

    Anyway.. it went smooth as a baby's bottom.. Thanks to all for the information..
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  7. #27
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    214

    Default Re: ability to define DB_CHARSET ?

    The numinix instructions are not fully accurate. And they have you touching files that don't need touching (such as the phpmailer file, etc). Use with caution.

    AND in v1.5.0+ the change is simplified: just update configure.php
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  8. #28
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,033
    Plugin Contributions
    32

    Default Re: ability to define DB_CHARSET ?

    Quote Originally Posted by DrByte View Post
    The numinix instructions are not fully accurate. And they have you touching files that don't need touching (such as the phpmailer file, etc). Use with caution.
    Understood sir.. I used what was useful from all sources taking heed to your other warnings about the Numinix article..
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  9. #29
    Join Date
    Oct 2008
    Posts
    591
    Plugin Contributions
    0

    Default Re: ability to define DB_CHARSET ?

    After update to "utf8"
    and upload the 2 files

    /admin/includes/extra_configures/my_db_charset.php
    includes/extra_configures/my_db_charset.php


    my home page text big font size - 3

    All ez pages also 3 size text .

    How can fixed all is 2 size ?

    Thanks

  10. #30
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,033
    Plugin Contributions
    32

    Default Re: ability to define DB_CHARSET ?

    Quote Originally Posted by DrByte View Post
    AND in v1.5.0+ the change is simplified: just update configure.php
    Just caught this.. are my eyes deceiving me?? In v1.5 I ONLY need to update the configure.php file??? What if I am upgrading?? do I make this change in the configure before doing the upgrade via the install script??
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

 

 
Page 3 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. v154 CHARSET / DB_CHARSET: Valid combinations?
    By lat9 in forum General Questions
    Replies: 2
    Last Post: 5 Feb 2016, 02:43 PM
  2. Diamond characters and I tried defining DB_CHARSET
    By lruskauff in forum Upgrading to 1.5.x
    Replies: 2
    Last Post: 14 Jan 2014, 06:23 AM
  3. Define Pages - How to define brand new page
    By hutch32804 in forum Customization from the Admin
    Replies: 4
    Last Post: 31 Oct 2009, 01:39 PM
  4. Uploading Ability?
    By wildkeith in forum General Questions
    Replies: 2
    Last Post: 22 Nov 2008, 04:59 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