Strange "bug" in dump ?
Dear all,
When doing a dump of a 8.1.17, database (that I have to reimport daily
into a 7.4.6), I have a strange bugs with accents...
First point, I had to add --insert.
But there is still a problem with accents.
If I say nothing the dump is utf8, or I can add -E=latin1.
But in both cases it fails, and there is a very strange error !
There is a "E" before the street field !
This is an extract of the dump :
'ST311PHANIE ROBERT', NULL, E'RTE DES TATTES D\\''OIE 5',
311 is shown instead of accent
Does someone knows what could be this problem ?
Denis
On Sat, Nov 28, 2009 at 12:59, Denis BUCHER <dbucherml@hsolutions.ch> wrote:
[...]
There is a "E" before the street field !
This is an extract of the dump :
'ST311PHANIE ROBERT', NULL, E'RTE DES TATTES D\\''OIE 5',
Sounds like escape quoting to me. You can read about it at
<http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html>.
I'm not sure how good 7.4.6 is at unicode-quoting, but I surmise this
could be the source of the error that it is not able to handle the
correct string quoting.
--
- Rikard - http://bos.hack.org/cv/
Rikard Bosnjakovic a �crit :
There is a "E" before the street field !
This is an extract of the dump :
'ST311PHANIE ROBERT', NULL, E'RTE DES TATTES D\\''OIE 5',
Sounds like escape quoting to me. You can read about it at
<http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html>.
I'm not sure how good 7.4.6 is at unicode-quoting, but I surmise this
could be the source of the error that it is not able to handle the
correct string quoting.
Oh yes, great, then it's not a bug but "String Constants with C-Style
Escapes" !
But this seems to be a 8.4 feature not supported by 7.4.6 ?
If you have an idea on how to have 7.4.6 accept it...
Thanks a lot for your help :-)
Denis
Denis BUCHER <dbucherml@hsolutions.ch> writes:
But this seems to be a 8.4 feature not supported by 7.4.6 ?
If you have an idea on how to have 7.4.6 accept it...
Better idea: expend your effort on getting off 7.4.x. It's going to
be EOL'd soon. Running a release as old as 7.4.6 doesn't seem very
advisable anyway.
regards, tom lane