Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    1

    Question Unanswered: pg_dump question - LOOK

    I'm a new member so I'd like to say hello, and I will be grateful for
    any help I may receive here.

    I am dumping my database to a text file (.sql), and pg_dump keeps encoding some of the data. For example, it encodes the words "Design Café" as: Design Caf\351

    How do I prevent this encoding?? If there is no way to prevent it, how can I convert it back to plain text? I want to import the data into a MySQL database.

    Please help.

    Thanks in advance!!
    Adam

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138

  3. #3
    Join Date
    Sep 2003
    Posts
    3

    Check encoding in you db

    and use iconv sh command to convert your file to correct mysql encoding.

Posting Permissions

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