UTF-8 Zen-Cart Tutorial for v1.3.x

[Spiritus]

you're right.. old database is in latin1.. Because I've made site on test server and there I didn't need utf-8..
Now I use english and Slovenian language pack and I need utf-8 for that new site.
What can I do now? I have problem with collation, I must somehow change older database to utf-8 and than import it to new one.
Am I right?
Please help..
tnx for reply

[CrystalKoi]

Converting them is not fun. I think someone did something like this, but off the top of my head, I can't remember.

You might be able to use easy populate module and pull all the data you need from one and put it in the other one. That would be easier I would think.

Good luck and just know that its always better to start with UTF-8.

Wish I had a better answer,

CKD

[Spiritus]

I found one great thread. I think it will help to everyone with this problems..

Collation change for SQL databases

It works ..

[CrystalKoi]

Cool, I will have to test this.

[nescaya]

Hello CrystalKoi
Thanks so much for your utf-8 files and tutorial. I have my shop set up and all works fine except for one small problem. When checking out in IE8 in Japanese, the checkout_payment page is not using the CSS stylesheet and is coming out in v large type. All other checkout pages display correctly. All pages display correctly in Firefox. Originally I thought it was because I was using Worldpay pages in English, but disabling Worldpay did not help.
I did look at the source and the page is calling for the correct stylesheet.
Also if I enable Paypal website payments, both the checkout_payment and payment_confirmation pages display wrongly when the customer chooses Paypal. Please, can you suggest where the problem may be arising.
Thanks

[adg_]

I've followed the instructions on CrystalKoi's site, for my JustHost.com ZenCart installation (it's ZenCart 1.3.8a [patched]). The DB seems set for uft8_general_ci collation beforehand, and then I update the english.php and query_factory.php pages as described in the UTF-8 Zen-Cart tutorial. After this, FireFox does display the page as utf-8.

I then proceeded with the Zen-Cart 1.3.8 Japanese Pack Install tutorial, but the Japanese language site goes to a blank page when I click the 'add to cart' button. The product gets added to the cart, but the redirect doesn't bring back a page (it's just blank). In english, this works just fine.

Is there something I can do to find out what's the problem?

I've done the tutorials twice now, each time with a fresh install, so I'm confident that I'm performing the steps OK. I do have a template that I'm using (apple_zen).

I've tried using the debug_log utility, but it doesn't place any log files in the /cache/ directory. Also, I've tried replacing the query_factory.php file from earlier in this thread, but it didn't do anything for me.

Thanks,

Alex

[adg_]

Yaay, I figured this out.

I must have not refreshed the /cache directory yesterday, because this morning it was filled with log files. Using those, I tracked down two problems.

1st. The /includes/languages/japanese.php file had extra spaces and a carriage return after the closing ?>

2nd. That file was not saved as UTF-8 without BOM. It was simply UTF-8. Using Notepad++ you have the option of saving without BOM (Byte Order Mark).

This page explains the issue:
https://www.zen-cart.com/tutorials/i...hp?article=396

So, long story short, the answers were all here in my case, I just didn't know what questions to ask (because I didn't check the logs).

[Asdesign]

Sorry to bump this off but I'm having a problem. My "product was added on date" displays in gibbrish. I'm using hebrew. Which file do I have to convert to UTF8 to make it work properly? Or is it SQL related? I fresh installed Zencart with UTF-8 support already built in.

[CrystalKoi]

Is your language file settings, example: english.php, is this set to utf-8 in the settings, not the file itself, which should also be utf-8, but what sets the source code to utf-8.

[Asdesign]

I saved my hebrew.php in dreamweaver with UTF-8 encoding (w/o bom of course) and inside the file it has utf-8 defined properly.

// charset for web pages and emails
define('CHARSET', 'utf-8');

Thing is, I don't know what generates the days and dates on Zen Cart...

This is the template I'm working on (hope you're using firefox):

http://www.hilapc.co.il/index.php?ma...&products_id=5

If you can see the characters properly (I mean, the hebrew stuff) then, you'll notice the culprit down below on the product info page, it's the last line in the middle box.