#265 TEXT field shows unicode in remote dump

2.5.0-rc2
closed
None
2
2003-06-18
2003-06-12
Anonymous
No

HOW TO DUPLICATE: From remote (??Unix??) box -
choose individual table, choose 'export.' Do single table
data dump from MySQL 3.23.54 to SQL file. Table must
contain 1 text field. Either view or save as file on local
system (doesn't matter.)

ISSUE: Dump is fine, except Text field which reports as
unicode rather than text in the .sql file. Thus a Windows
system cannot retrieve and edit the field contents in the
dump with a simple text editor.

Discussion

  • DUMP of single table from remote

     
    Attachments
  • Michal Čihař
    Michal Čihař
    2003-06-13

    • priority: 5 --> 2
    • assigned_to: nobody --> nijel
     
  • Michal Čihař
    Michal Čihař
    2003-06-13

    Logged In: YES
    user_id=192186

    If you use unicode translation, you can select charset of
    dump, if you don't phpMyAdmin won't produce unicode data
    (unless they are in database).

    If you mean 0x... values, it is not unicode, it's just hex
    dump of text and was fixed in 2.5.0-final...

     
  • Michal Čihař
    Michal Čihař
    2003-06-13

    • assigned_to: nijel --> nobody
    • labels: 509096 -->
    • milestone: 297990 -->
     
  • Michal Čihař
    Michal Čihař
    2003-06-13

    Logged In: YES
    user_id=192186

    Moved to support requests...

     
  • Michal Čihař
    Michal Čihař
    2003-06-13

    • assigned_to: nobody --> nijel
     
  • Michal Čihař
    Michal Čihař
    2003-06-18

    • milestone: --> 2.5.0-rc2
    • status: open --> closed
     
  • Michal Čihař
    Michal Čihař
    2003-06-18

    Logged In: YES
    user_id=192186

    No reply -> upgrade solves this...