Forums / Currencies & Sales Taxes, VAT, GST, etc. / Upgrading a Norwegian - English website to 1.5.1 - currency symbols

Upgrading a Norwegian - English website to 1.5.1 - currency symbols

Started by delia on 5 Nov 2013, 5:50 PM · Views: 2,205

Results 1 to 5 of 5
5 Nov 2013, 5:50 PM
#1
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Upgrading a Norwegian - English website to 1.5.1 - currency symbols

Tis a very complicated situation. A multi-language cart upgraded to 1.5.1. Upgrade went fine, then moved servers and the ckeditor stopped working at some point. I decided to go ahead and upgrade the database to utf-8 using Dr. Byte's script. When I did that some of the Norwegian words in the database were truncated - no rhyme or reason but did happen at a Norwegian character. Just not the same character or every time. EEK! Got no clue why that happened but it was a major shock and major full site screw up.

I fixed that by copying over the product, category and attributes text from the pre conversion database and then uploading the most recent Norwegian language set in admin. Admin looks okay now and site looks okay.

Then I was left with one problem - the dropdowns (dynamic dropdown mod) are showing Medium ( NOK.249.00) with that space between the left parentheses and the NOK occupied by the diamond symbol which is usually created by database char set problems. The database symbol for Krone is just the NOK. in front so there's no real reason to have anything between parentheses and the NOK. yet there it is.

I have not used the Norwegian main language file for the catalog side with the utf-8 changes because then my copied over text from the old database goes screwy since I copied from a non-converted database. But even using that utf-8 file does not fix the problem in the dropdown either.

So any enlightenment as to what could be causing that one stupid diamond?

And Dr. Byte, please take note that the UTF-8 conversion was disastrous for Norwegian.

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

5 Nov 2013, 10:12 PM
#2
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Upgrading a Norwegian - English website to 1.5.1 - currency symbols

fwiw... when I upgraded a number of my "english only" sites to utf8 using Dr Bytes mod, It truncated ezpages and newsletters at single quotes and other punctuation.
My solution was to comment out the intermediate "blob" and "binary" steps.
This then converted all these sites fine for me.

5 Nov 2013, 11:01 PM
#3
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: Upgrading a Norwegian - English website to 1.5.1 - currency symbols

I didn't run into that when I used it before but one test is so not enough with this stuff.

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

6 Nov 2013, 6:59 PM
#4
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

Re: Upgrading a Norwegian - English website to 1.5.1 - currency symbols

FWIW, I've used a_berenzin's http://www.zen-cart.com/downloads.php?do=file&id=1318 (Convert db2utf8) on a bunch of sites with great success. When you created the database, did you make sure to set the default collation to utf8_general_ci? What collation did you specify when you imported the data? Most of the mySQL exports I've seen use UTF8 character sets for the export.

6 Nov 2013, 7:09 PM
#5
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: Upgrading a Norwegian - English website to 1.5.1 - currency symbols

I was converting an existing database. I did not create a new one and import the old one. That had not even occurred to me. But if you are correct then that might be a lot safer. So simple - too simple a solution?

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo