Re: utf8 database not dumping utf8 characters

Поиск
Список
Период
Сортировка
От Matt Williams
Тема Re: utf8 database not dumping utf8 characters
Дата
Msg-id 2F1A03239AE84E5F8217570AE41AA4C4@williams-tech.net
обсуждение исходный текст
Ответ на Re: utf8 database not dumping utf8 characters  (Steve Crawford <scrawford@pinpointresearch.com>)
Ответы Re: utf8 database not dumping utf8 characters  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-admin
With that same dump file that is displaying incorrectly open in vim, I can paste in the utf8 character I provided as an example and it displays correctly.

-- 
Matt Williams
Sent with Sparrow

On Friday, April 6, 2012 at 4:03 PM, Steve Crawford wrote:

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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Whitney
Дата:
Сообщение: Re: utf8 database not dumping utf8 characters
Следующее
От: Matt Williams
Дата:
Сообщение: Re: utf8 database not dumping utf8 characters