Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008

    MySQL - Convert data to UTF-8

    Hi there,

    I have a database in which all the columns have collation as utf8_general_ci.

    Previously I was connecting to the database and inserting data without using SET names utf8, therefore a lot of the data has been inserted with the wrong encoding.

    The problem is all the data before using that has been stored incorrectly, and wierd characters are displayed instead.

    How can I convert that data into utf8? I think it must be mixed now, as I changed it to use set names utf8 so some data is correct.


  2. #2
    Join Date
    Mar 2008
    I can get access to a shell, but how do I dump it from phpmyadmin first?

  3. #3
    Join Date
    May 2008
    I'm not sure how you'd do the phpmyadmin thing with the additional arguments; I don't use phpmyadmin that much. Sorry...
    Dan Hildebrandt, Developer / Support, WebGroup Media LLC. -
    Cerberus Helpdesk 5.x is a CRM toolkit. Remember anything about anybody, swiftly reply to a flood of e-mail,
    capture feedback organically, track time, flag opportunities, share tasks, and more.

Similar Threads

  1. Convert files to MySQL DBs
    By zacharooni in forum Hosting Security and Technology
    Replies: 2
    Last Post: 12-30-2006, 12:50 PM
  2. Convert MS SQL 7 data to a MySQL ??
    By spiceman in forum Programming Discussion
    Replies: 10
    Last Post: 09-21-2004, 08:30 PM
  3. Convert Access DB into MySQL??
    By Two-A-T in forum Hosting Software and Control Panels
    Replies: 1
    Last Post: 06-15-2003, 07:50 PM
  4. Convert MySQL database?
    By bear in forum Programming Discussion
    Replies: 2
    Last Post: 06-11-2003, 06:37 AM
  5. Convert Access to MySQL
    By Juan in forum Hosting Security and Technology
    Replies: 6
    Last Post: 08-24-2001, 06:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts