Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    7,971
    Plugin Contributions
    65

    Default Convert Database to UTF8 (convert_db2utf8) [Support Thread]

    This plugin's been around for a while (https://www.zen-cart.com/downloads.php?do=file&id=1318) and deserves its own support thread!

    I've just submitted v4 to the Plugins area. That version also checks the overall database collation and, if it's not currently utf8, makes that conversion, too!

    The previous versions of this plugin only focused on converting the table-based collations. If a database started with a collation of latin1_general_ci, for instance, the previous versions would properly convert all the database tables to use utf8_general_ci but leave the overall collation unchanged.

    The next time a new table is added to that database, that table and all character fields within it would default to the database's default: latin1_general_ci. Not a good thing!

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    7,971
    Plugin Contributions
    65

    Default Re: Convert Database to UTF8 (convert_db2utf8) [Support Thread]

    v4 is now available for download from the Plugins.

  3. #3
    Join Date
    Feb 2012
    Posts
    26
    Plugin Contributions
    0

    Default Re: Convert Database to UTF8 (convert_db2utf8) [Support Thread]

    Hi

    I have latin1 and utf8 tables in my database, is this module ok to use on this?

    Regards

    Mike

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    7,971
    Plugin Contributions
    65

    Default Re: Convert Database to UTF8 (convert_db2utf8) [Support Thread]

    Quote Originally Posted by mike14017 View Post
    Hi

    I have latin1 and utf8 tables in my database, is this module ok to use on this?

    Regards

    Mike
    Yes, that's the problem that this module solves! The plugin's processing will convert the database, all tables and their fields to utf8 ... just remember to update your configure.php files (both admin and storefront) to identify that the database's DB_CHARSET is now utf8 instead of latin1.

    You should also change the CHARSET definition in your store's base language files (e.g. /includes/languages/english.php, /YOUR_ADMIN/includes/languages/english.php) to reflect a utf8-type character encoding.

  5. #5
    Join Date
    Feb 2012
    Posts
    26
    Plugin Contributions
    0

    Default Re: Convert Database to UTF8 (convert_db2utf8) [Support Thread]

    Hi

    Done all that and converted DB. Everything seems fine.

    What a cracking module, thank you.

    Mike

  6. #6
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,115
    Plugin Contributions
    1

    Default Re: Convert Database to UTF8 (convert_db2utf8) [Support Thread]

    Thanks for a great tool Cindy - fast and seamless.

    cheers,
    Mike

  7. #7
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    7,971
    Plugin Contributions
    65

    Default Re: Convert Database to UTF8 (convert_db2utf8) [Support Thread]

    Quote Originally Posted by shags38 View Post
    Thanks for a great tool Cindy - fast and seamless.

    cheers,
    Mike
    Mike, it's a collaborative effort ... with the primary thanks going to @a_berenzin (original author) for the idea and the base processing. Additional changes by @mc12345678 and myself were simply adding "frosting to the cake" to improve its processing.

 

 

Similar Threads

  1. v155 Database I/O Manager (DbIo) Plugin [Support Thread]
    By lat9 in forum All Other Contributions/Addons
    Replies: 171
    Last Post: 14 Sep 2018, 08:17 PM
  2. Hebrew Support - new release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 9
    Last Post: 28 Feb 2016, 02:21 AM
  3. 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
  4. Database upgrade success but has one strange utf8 table
    By dharma in forum Upgrading from 1.3.x to 1.3.9
    Replies: 8
    Last Post: 2 Nov 2011, 04:54 PM
  5. Replies: 3
    Last Post: 4 Sep 2007, 01:06 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