Re: utf8 database not dumping utf8 characters

Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> · Fri, 06 Apr 2012 13:03:58 -0700



    On 04/06/2012 12:55 PM, Matt Williams wrote:
    
      I have a database that is utf8 and displays utf8 values
        correctly in psql. When dumped, it displays the utf8 characters
        incorrectly. ie. ö turns into Ã
      

      In the header of the dump
          file, I have:
      

      SET client_encoding = 'UTF8';
      

      So I'm not sure where the disconnect is?
      

      Thoughts?
      

      Thanks,
      
        
        -- 
        Matt Williams
        Sent with Sparrow
        

    With what are you viewing the dump file and is everything in the
    chain (terminal, less/vi/...) set to interpret/display that data as
    UTF8? You can always use a hex-dump program to see the actual bytes
    in the file and determine if they are what you expect for UTF8.

    
    Cheers,

    Steve