Thread: UTF8 Conversion

Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    108
    Plugin Contributions
    0

    Default UTF8 Conversion

    My site has been converted to v1.5.1 from 1.3.9h and is showing some odd characters. DrByte recommended this thread as a fix.

    http://www.zen-cart.com/content.php?...8859-1-to-utf8

    My question is that while this is good information (great information, actually), shouldn't I be moving forward with the new character set? I have read so many articles, and none seem to offer the solution I need. I have seen people revert back to the latin character set, and other have altered the character set in the database to mixed results - and many warnings.

    1) In a perfect world, what should the database setting be for v1.5.1? I expect UTF8 and if that is the case...
    2) Is there a way to convert it? Even manually changing 100 or so files to UTF8 is fine with me.
    3) Will that corrupt existing data? Of course, I will back everything up first.

    As it is now, I can delete the offending characters. Some are dashes, some are ampersands, and some are foreign characters from customers names and I have no idea what to call them. Simply re-entering them solves the problem, but since my database is not in UTF8 is this just a band aid?

    Is there a safe script that can do this for me?

    Sorry for all the questions, but I am almost done the conversion to v1.5.1 and there are only a few things left to deal with.

  2. #2
    Join Date
    Oct 2007
    Posts
    328
    Plugin Contributions
    0

    Default Re: UTF8 Conversion

    Im in same situation. Just upgraded from 1.3.8a to 1.5.1. (old DB and new cart files). About half of the DB tables are latin the other half utf8 (I don't know how that happened). Site is in english only but I have many international customers, so I would like to change from latin to utf8. There are lots of threads discussing how to do this but none of them seems to mention a safe way to do it. Can this not be done safely? Step by step instructions would be great.

 

 

Similar Threads

  1. Convert DB to utf8 (admin tool)
    By a_berezin in forum All Other Contributions/Addons
    Replies: 10
    Last Post: 25 Sep 2012, 03:02 PM
  2. v150 A few UTF8 questions
    By hubert in forum Upgrading to 1.5.x
    Replies: 8
    Last Post: 14 Apr 2012, 05:25 AM
  3. UTF8 new installation
    By tony_sar in forum Installing on a Windows Server
    Replies: 1
    Last Post: 7 May 2009, 12:28 AM
  4. search UTF8
    By hugo13 in forum Bug Reports
    Replies: 3
    Last Post: 8 Mar 2009, 02:28 PM
  5. UTF8 and Number
    By nnitin in forum Addon Language Packs
    Replies: 5
    Last Post: 24 Nov 2008, 01:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR