Re: UTF8 with BOM support in psql

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: UTF8 with BOM support in psql
Дата
Msg-id
7995.1258405313@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
UTF8 with BOM support in psql Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Bruce Momjian <bruce@momjian.us>
Re: UTF8 with BOM support in psql Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: UTF8 with BOM support in psql Tom Lane <tgl@sss.pgh.pa.us>
Re: UTF8 with BOM support in psql Andrew Dunstan <andrew@dunslane.net>
Re: UTF8 with BOM support in psql Tom Lane <tgl@sss.pgh.pa.us>
Re: UTF8 with BOM support in psql David Christensen <david@endpoint.com>
Re: UTF8 with BOM support in psql Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Andrew Dunstan <andrew@dunslane.net>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Chuck McDevitt <cmcdevitt@greenplum.com>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Chuck McDevitt <cmcdevitt@greenplum.com>
Re: UTF8 with BOM support in psql Andrew Dunstan <andrew@dunslane.net>
Re: UTF8 with BOM support in psql Tom Lane <tgl@sss.pgh.pa.us>
Re: UTF8 with BOM support in psql Andrew Dunstan <andrew@dunslane.net>
Re: UTF8 with BOM support in psql Tom Lane <tgl@sss.pgh.pa.us>
Re: UTF8 with BOM support in psql Chuck McDevitt <cmcdevitt@greenplum.com>
Re: UTF8 with BOM support in psql Andrew Dunstan <andrew@dunslane.net>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Tom Lane <tgl@sss.pgh.pa.us>
Re: UTF8 with BOM support in psql Andrew Dunstan <andrew@dunslane.net>
Re: UTF8 with BOM support in psql Tom Lane <tgl@sss.pgh.pa.us>
Re: UTF8 with BOM support in psql Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: UTF8 with BOM support in psql Tom Lane <tgl@sss.pgh.pa.us>
Re: UTF8 with BOM support in psql Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: UTF8 with BOM support in psql Andrew Dunstan <andrew@dunslane.net>
Re: UTF8 with BOM support in psql Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: UTF8 with BOM support in psql Andrew Dunstan <andrew@dunslane.net>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Andrew Dunstan <andrew@dunslane.net>
Re: UTF8 with BOM support in psql Peter Eisentraut <peter_e@gmx.net>
Re: UTF8 with BOM support in psql Tom Lane <tgl@sss.pgh.pa.us>
Re: UTF8 with BOM support in psql Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: UTF8 with BOM support in psql Tom Lane <tgl@sss.pgh.pa.us>
Re: UTF8 with BOM support in psql Tom Lane <tgl@sss.pgh.pa.us>
Re: UTF8 with BOM support in psql Magnus Hagander <magnus@hagander.net>
Re: UTF8 with BOM support in psql "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Peter Eisentraut  writes:
> I'm not sure if replacing a BOM by three spaces is a good way to
> implement "eating", because it might throw off a column indicator
> somewhere, say, but I couldn't reproduce a problem.  Note that the U
> +FEFF character is defined as *zero-width* non-breaking space.

So wouldn't it be better to remove the three bytes, rather than
replace with spaces?  The latter will certainly confuse clients that
think that "column 1" means what they think is the first character.
A syntax error in the first line of the file should be sufficient
to demonstrate the issue.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Andreas Kretschmer
Дата:
Сообщение: Re: Update on Insert
От: Alex Hunsaker
Дата:
FAQ