ability to define DB_CHARSET in v1.3.9?

**davico** · 26 Apr 2010, 02:44 PM

hello all
i see in the new version that :

Code:

Added ability to define DB_CHARSET to automatically trigger a mysql SET NAMES statement if needed for things like UTF8 support, preventing the need to edit the db class

so where should i define this???

**DrByte** · 26 Apr 2010, 06:26 PM

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

NOTES:
- This is only applicable to v1.3.9x. It will NOT work in older versions, and is not applicable to the future version v2.x since it will be utf8 already.

**dharma** · 26 Apr 2010, 07:58 PM

I had to add this line of code when I upgraded to php 5 [ZenCart 138 code doesn't set the encoding of the client connection, so when connecting to a MySQL 5 server, the server will return utf-8 encoded text.]

PHP Code:


the code added to includes/classes/db/mysql/query_factory.php line 36:

    mysql_set_charset('latin1');

Should I keep this or go with the new code

PHP Code:


/includes/extra_configures/my_db_charset.php <?php define('DB_CHARSET', 'your_charset_here');

I plan to upgrade this week to 1.39a

**DrByte** · 26 Apr 2010, 09:20 PM

Using the DB_CHARSET define replaces the need for editing query_factory.php, so you should remove your custom code from that file.

**dharma** · 26 Apr 2010, 09:24 PM

thanks dr byte!

**davico** · 27 Apr 2010, 12:00 PM

thank you

**tweedle** · 1 Sep 2010, 02:45 PM

Originally Posted by DrByte

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

NOTES:
- This is only applicable to v1.3.9x. It will NOT work in older versions, and is not applicable to the future version v2.x since it will be utf8 already.

Hi all,

this worked perfectly for German with utf8 and the '?>' at the end of the php file.

Many thanks to all

Regards,

Jack

**DrByte** · 1 Sep 2010, 06:14 PM

Originally Posted by tweedle

and the '?>' at the end of the php file.

Jack, that '?>' is not necessary: http://tutorials.zen-cart.com/index.php?article=313

**parkerlewis** · 8 Nov 2010, 09:06 PM

Hi all. I have been successfully using Zen Cart for 2 years now....Me and my wife work at it full time, doing an online bicycle shop.

Anyway, I am about to build a separate shop and am trying to get the UTF-8 settings sorted.

I have 1.3.9 and so do not need to modify query_factory.php

I just can not understand what I am meant to do instead.... sorry for being so ignorant. I just find the instructions on this thread too brief/vague to get my head around.

----
Here are my questions regarding DRBYTES post/instructions....

----
DrByte said//

Create a new file for it: (((I do this by making a new file in smultron or text editor?)))

/includes/extra_configures/my_db_charset.php
Code:

<?php define('DB_CHARSET', 'your_charset_here'); (((so I type UTF-8 in this space between the apostrophes?)))

Do the same with: /admin/includes/extra_configures/my_db_charset.php

------
I hope that makes sense.....

**cjcraven** · 15 Mar 2011, 05:36 AM

Originally Posted by DrByte

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

NOTES:
- This is only applicable to v1.3.9x. It will NOT work in older versions, and is not applicable to the future version v2.x since it will be utf8 already.

Created and uploaded as outlined, the result is a DB collation of latin1_general_ci in the tables, I am now manually changing each field. Adding the 2 files causes the store and admin screen to go blank. I'm not clear why I had this problem.