Hi
I've moved an installation of zencart. Both version 1.3.0.1
From
php 4.4.2
Mysql 4.1.18
To
php 4.4.1
Mysql 4.0.25
I had to change some information in the sql file ENGINE=MyISAM DEFAULT CHARSET=latin1 to TYPE=MyISAM
The installation worked but there are some funny characters in my text such as ’
etc.
Is there anyway of getting rid of them without manually doing it by hand.
Results 1 to 3 of 3
-
13 Jul 2006, 09:12 PM #1
New Zenner
- Join Date
- Apr 2006
- Posts
- 20
- Plugin Contributions
- 0
Database showing funny characters
-
13 Jul 2006, 09:44 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 58,459
- Blog Entries
- 3
- Plugin Contributions
- 111
Re: Database showing funny characters
If you are able to change your new database's charset or collation settings to latin1, then those characters may convert properly for you. (Talk to your host about what options you have for those settings... you may have to do it table-by-table too.)
Otherwise, manual is likely your only option..
Zen Cart - putting the dream of business ownership within reach of anyone!
Donations always welcome: www.zen-cart.com/donate
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.
-
15 Jul 2006, 01:45 PM #3
Totally Zenned
- Join Date
- Nov 2004
- Location
- Norfolk, United Kingdom
- Posts
- 3,102
- Plugin Contributions
- 2
Re: Database showing funny characters
This is getting to be a major problem. Modern versions of MySQL/phpMyAdmin use utf8-en as their default character set. Whilst you can usually specify Latin 1 for uploading files, you generally don't have an option when it comes to downloading files.
The problem, as far as I can see it, is this: utf8-en is what it says "English" (only), while Latin 1 covers all Western European languages and renders non-English characters correctly - including £ and € - which are garbled by UTF8-en, along with any customer name which uses any non-English characters.
Vger
Bookmarks