Re: COPY 'invalid byte sequence for encoding "UTF8": 0xff'

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: COPY 'invalid byte sequence for encoding "UTF8": 0xff'
Дата
Msg-id 49EE2BE7.2000402@pinpointresearch.com
обсуждение исходный текст
Ответ на COPY 'invalid byte sequence for encoding "UTF8": 0xff'  (Chris Worley <chris.worley@timco.aero>)
Список pgsql-general
> hmm, I was shelling out and using psql and piping the data to another
> file.  Not using the dbi stuff with perl.
>
> Guess i can use a regular expression and review the link you sent me
> and escape them my self.
>
Don't *ahem* quote me on this as I haven't been using Perl for a while
but it should be something similar to:
$quoted_data = $dbh->quote($data, PG_BYTEA)

If not, I'm sure the documentation for the "quote" function will set
things straight.

Cheers,
Steve


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Yet another "drop table vs delete" question
Следующее
От: Christophe
Дата:
Сообщение: Re: Yet another "drop table vs delete" question