| Lists: | pgsql-bugs |
|---|
| From: | "Peter Jukel" <pjukel(at)triplehash(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM |
| Date: | 2010-03-31 04:41:14 |
| Message-ID: | 201003310441.o2V4fEMm048826@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5398
Logged by: Peter Jukel
Email address: pjukel(at)triplehash(dot)com
PostgreSQL version: 8.4
Operating system: Mac OSX 10.5.8
Description: psql gives syntax error on .sql files with UTF-8 BOM
Details:
The psql command gives syntax errors when fed .sql files that are saved with
encoding "UTF-8" and contain a BOM (byte order marker). When the same file
is saved using the encoding "UTF-8, no BOM", the syntax error is removed.
The irony is that the query tool supplied with PostGres (PGAdmin) saves with
the BOM. So it would appear to me that any script written in this tool would
display a syntax error.
Regards
Peter
| From: | Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | "Peter Jukel" <pjukel(at)triplehash(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5398: psql gives syntax error on .sql files with UTF-8 BOM |
| Date: | 2010-04-01 00:53:42 |
| Message-ID: | 20100401095342.D026.52131E4D@oss.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Peter Jukel" <pjukel(at)triplehash(dot)com> wrote:
> PostgreSQL version: 8.4
>
> The psql command gives syntax errors when fed .sql files that are saved with
> encoding "UTF-8" and contain a BOM (byte order marker). When the same file
> is saved using the encoding "UTF-8, no BOM", the syntax error is removed.
It will be improved in 9.0, the next release.
Ignore leading UTF-8-encoded Unicode byte-order marker in psql
http://developer.postgresql.org/pgdocs/postgres/release-9-0.html#AEN98917
Regards,
---
Takahiro Itagaki
NTT Open Source Software Center