Re: multiline CSV fields

Поиск
Список
Период
Сортировка
От Patrick B Kelly
Тема Re: multiline CSV fields
Дата
Msg-id ED80A94A-34C1-11D9-B14C-000A958A3956@patrickbkelly.org
обсуждение исходный текст
Ответ на Re: multiline CSV fields  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Nov 12, 2004, at 12:20 AM, Tom Lane wrote:

> Patrick B Kelly <pbk@patrickbkelly.org> writes:
>> I may not be explaining myself well or I may fundamentally
>> misunderstand how copy works.
>
> Well, you're definitely ignoring the character-set-conversion issue.
>

I was not trying to ignore the character set and encoding issues but 
perhaps my assumptions are naive or overly optimistic. I realized that 
quotes are not as consistent as the NL characters but I was assuming 
that some encodings would escape to ASCII or a similar encoding like 
JIS Roman that would simplify recognition of the quote character. 
Unicode files make recognizing other punctuation like the quote fairly 
straightforward and to the naive observer, the code in CopyReadLine as 
it is currently written appears to handle multi-byte encodings such as 
SJIS that may present characters below 127 in trailing bytes.

As I said, perhaps I was oversimplifying. Is there a regression test 
set of input files for that I could review to see all of the supported 
encodings?


Patrick B. Kelly
------------------------------------------------------                              http://patrickbkelly.org



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: multiline CSV fields
Следующее
От: "Oleg I.Ivanov"
Дата:
Сообщение: Database reverse engineering