found this approach to converting table content from latin1 to utf8:
blog.makezine.com/2007/05/08/mysql-database-migration-latin/
haven't tried it yet so not sure but thought post it for anyone with more experience with this who could comment
seems a good idea overall to convert to utf8 if possible
hth
Results 1 to 2 of 2
-
23 Jul 2012, 12:03 AM #1
New Zenner
- Join Date
- Jul 2004
- Posts
- 38
- Plugin Contributions
- 0
2007 technique for converting a latin1 table to utf8
peace
-
23 Jul 2012, 12:06 AM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: 2007 technique for converting a latin1 table to utf8
Never attempt ANY such conversion on a live site. Ever. Period.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
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.
Reply With Quote
Similar Threads
-
v151 UTF8: Site full of question marks. Latin1: no product description in admin
By vandiermen in forum Upgrading to 1.5.xReplies: 4Last Post: 2 Dec 2013, 07:43 PM -
v151 *[Done v1.6.0] Fresh install or upgrade using Latin1 still results in utf8
By lat9 in forum Bug ReportsReplies: 2Last Post: 26 Sep 2012, 08:55 PM -
v150 Converting database back to latin1
By lat9 in forum General QuestionsReplies: 0Last Post: 7 Apr 2012, 01:42 PM -
made products_description table utf8 compatible?
By soki in forum General QuestionsReplies: 2Last Post: 22 May 2008, 06:22 PM -
Problem with size and maxlength after converting database to UTF8
By Ronson in forum General QuestionsReplies: 3Last Post: 4 Sep 2007, 01:06 PM
Bookmarks