ability to define DB_CHARSET in v1.3.9?

[power35]

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

[DrByte]

Blank page: https://www.zen-cart.com/tutorials/index.php?article=82

[cjcraven]

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');
?>

[pizza392]

Create a new file for it:

/includes/extra_configures/my_db_charset.php

<?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 ?

[DrByte]

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.

[DivaVocals]

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

[DrByte]

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

[DivaVocals]

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

[dmagic]

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

[DivaVocals]

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??