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
- 58,265
- Blog Entries
- 3
- Plugin Contributions
- 106
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!
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.
Reply With Quote
Similar Threads
-
v150 Converting database back to latin1
By lat9 in forum General QuestionsReplies: 0Last Post: 7 Apr 2012, 01:42 PM -
Database upgrade success but has one strange utf8 table
By dharma in forum Upgrading from 1.3.x to 1.3.9Replies: 8Last Post: 2 Nov 2011, 04:54 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 -
New for 2007 - Under Product name
By Marg in forum General QuestionsReplies: 8Last Post: 8 Mar 2007, 01:53 AM
Bookmarks