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