Re: Frustrated...pg_dump/restore

Поиск
Список
Период
Сортировка
От Jeff Amiel
Тема Re: Frustrated...pg_dump/restore
Дата
Msg-id 156429.57632.qm@web65504.mail.ac4.yahoo.com
обсуждение исходный текст
Ответ на Re: Frustrated...pg_dump/restore  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: Frustrated...pg_dump/restore  (Marco Colombo <pgsql@esiway.net>)
Список pgsql-general
--- On Mon, 10/6/08, Scott Marlowe <scott.marlowe@gmail.com> wrote:

> I'm wondering if the OP has some line breaks in his
> data that are
> getting misinterpreted, or maybe his encoding on the two
> dbs is
> different and he's not taking care of that.


Ahhh....
*looks at encoding*

Well..they are both the same...BUT...they are set to
ENCODING = 'SQL_ASCII';

That explains a lot....they should probably be set to Unicode UTF8....
Duh!!!!

Any way to change encoding without dumping/restoring database?







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

Предыдущее
От: Keaton Adams
Дата:
Сообщение: Clarification on documentation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: function returning setof..select versus select * from