Professional Web Applications Themes

latin1 to utf8 with phpMyAdmin - MySQL

Hi, I'm trying to convert a database with latin1 cht to utf8. I have exported all data to a file using phpMyAdmin. Then, I've created a new database using UTF8 cht and finally I have imported all data using phpMyAdmin (removing all information about cht and collation) Tables and fields have UTF8 cht but data inside the tables are not converted to UTF8 format. Any idea? Thanks...

  1. #1

    Default latin1 to utf8 with phpMyAdmin

    Hi,
    I'm trying to convert a database with latin1 cht to utf8.
    I have exported all data to a file using phpMyAdmin. Then, I've
    created a new database using UTF8 cht and finally I have imported
    all data using phpMyAdmin (removing all information about cht and
    collation)

    Tables and fields have UTF8 cht but data inside the tables are not
    converted to UTF8 format.

    Any idea?
    Thanks

    buendias.web Guest

  2. #2

    Default Re: latin1 to utf8 with phpMyAdmin

    > I'm trying to convert a database with latin1 cht to utf8. 


    If you still have the original database (or convert it back to latin1):

    ALTER TABLE <table name> CONVERT TO utf8;

    Just run this query on all the tables you want to convert. That should
    be all.

    Best regards
    Dikkie Guest

  3. #3

    Default Re: latin1 to utf8 with phpMyAdmin

    On 18 mayo, 12:27, Dikkie Dik <org> wrote: 

    >
    > If you still have the original database (or convert it back to latin1):
    >
    > ALTER TABLE <table name> CONVERT TO utf8;
    >
    > Just run this query on all the tables you want to convert. That should
    > be all.
    >
    > Best regards[/ref]

    Thanks. I'll try it next time.
    This time I have exported database with phpMyAdmin and then I have run
    a php script to convert sql file to utf8 (by the use of utf8_encode
    function) Then, I have imported the sql file (what a mess!) and it
    works.
    Best regards.

    buendias.web Guest

Similar Threads

  1. Loading ISO-8859 (Latin1) characters from XML
    By sake_boy in forum Macromedia Flash Data Integration
    Replies: 2
    Last Post: August 30th, 03:28 PM
  2. utf8 & Jos? Feliciano
    By weblingual in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: March 22nd, 11:37 PM
  3. UTF8 encode
    By Pluda in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: February 24th, 06:15 PM
  4. utf8 -> latin2
    By Bedo Sandor in forum Ruby
    Replies: 1
    Last Post: November 14th, 03:31 PM
  5. #9188 [Com]: it seems that mysql-module doesn't support any chts except latin1
    By makisfm at mailbox dot gr in forum PHP Development
    Replies: 0
    Last Post: September 2nd, 06:49 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139