Professional Web Applications Themes

mysqldump encoding - MySQL

On Apr 18, 9:46 am, Willem Bogaerts wrote in comp.databases.mysql:  Hi there, I'm having an encoding related issue with the mysqldump utility under WinXP and recoding it to Latin1 respectively. When I create the dump it is UTF-8 Unicode English text, with very long lines, with CRLF line terminators After I recode it with recode utf8..latin1 mysqldump.sql it is ISO-8859 English text, with very long lines, with CRLF line terminators which is what I wanted, but when I take a closer look at the converted file I can see that some characters seem to have been swallowed by the recoding ...

  1. #1

    Default mysqldump encoding

    On Apr 18, 9:46 am, Willem Bogaerts wrote in comp.databases.mysql: 


    Hi there,

    I'm having an encoding related issue with the mysqldump utility under
    WinXP and recoding it to Latin1 respectively.

    When I create the dump it is

    UTF-8 Unicode English text, with very long lines, with CRLF line
    terminators

    After I recode it with

    recode utf8..latin1 mysqldump.sql

    it is

    ISO-8859 English text, with very long lines, with CRLF line
    terminators

    which is what I wanted, but when I take a closer look at the converted
    file I can see that some characters seem to have been swallowed by the
    recoding process. And the strange thing is that those characters are
    not even special characters.

    Any idea how to get an uncorrupted mysqldump in latin1 encoding? Is
    there a direct way or an option in the mysqldump utility I might have
    overlooked?

    Any pointers would be very much appreciated.

    Cheers, Nick

    Nick Guest

  2. #2

    Default Re: mysqldump encoding

    On Jul 26, 5:02 pm, Nick Weisser <com> wrote: 

    It seems that I've found the culprit. I've been using recode under
    cygwin. When I recode under Debian the conversion seems to be fine (no
    swallowed characters) and I can import the SQL dump without any
    issues.

    It's the little things that always cause the problems (Der Teufel
    steckt im Detail!)

    Cheers, Nick

    Nick Guest

  3. #3

    Default Re: mysqldump encoding

    == Quote from Nick Weisser (com)'s article 
    > It seems that I've found the culprit. I've been using recode under
    > cygwin. When I recode under Debian the conversion seems to be fine (no
    > swallowed characters) and I can import the SQL dump without any
    > issues.
    > It's the little things that always cause the problems (Der Teufel
    > steckt im Detail!)
    > Cheers, Nick[/ref]

    glad you found a solution; however, when running mysqldump, keep in mind , that
    you can specify the character set on the command line optinally together with line
    and field terminators.

    --
    POST BY: lark with PHP News Reader
    lark Guest

Similar Threads

  1. Need mysqldump help
    By SergioQ in forum MySQL
    Replies: 0
    Last Post: September 25th, 06:06 PM
  2. Having trouble with mysqldump
    By flarosa in forum MySQL
    Replies: 1
    Last Post: April 28th, 10:56 PM
  3. Help with mysqldump...
    By Mangina in forum PHP Development
    Replies: 4
    Last Post: February 9th, 09:24 PM
  4. [PHP] mysqldump
    By Marios Adamantopoulos in forum PHP Development
    Replies: 2
    Last Post: July 25th, 05:53 PM
  5. mysqldump
    By Marios Adamantopoulos in forum PHP Development
    Replies: 2
    Last Post: July 25th, 03:53 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
  •  

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