On Tue, Mar 22, 2005 at 09:28:17PM -0500, Carlos Moreno wrote:
> >I guess what changed from version 7.4.x to 8.0 is that the default
> >server_encoding changed?
>
> Some further digging through the documentation reveals (in addition
> to the fact that I seem to be an incompetent when it comes to
[...]
This makes sense to me, yes. The reason why I'm a bit lost is that
we never did anything whatsoever with respect to encoding. Oddly
enough, I couldn't find much about this in the docs.
[...]
I guess what changed from version 7.4.x to 8.0 is that the default
server_encoding changed?
Some f
Thanks again, Alvaro!
Alvaro Herrera wrote:
So, our system (CGI's written in C++ running on a Linux server)
simply takes whatever the user gives (properly validated and
escaped) and throws it in the database. We've never encountered
any problem (well, or perhaps it's the opposite? Perhaps we've
On Sun, Mar 20, 2005 at 10:02:24AM -0500, Carlos Moreno wrote:
Carlos,
> Carlos
> --
> PS: I have a strict white-list anti-spam filter in place, which
> is why a direct e-mail would be rejected -- let me know if
> you want to write directly through e-mail, so that I can
> add you to t
On Sun, Mar 20, 2005 at 10:02:24AM -0500, Carlos Moreno wrote:
Carlos,
> So, our system (CGI's written in C++ running on a Linux server)
> simply takes whatever the user gives (properly validated and
> escaped) and throws it in the database. We've never encountered
> any problem (well, or perha
Hi Alvaro, thanks for your reply!
Alvaro Herrera wrote:
psql:db_backup.sql:1548: ERROR: invalid byte sequence for encoding
"UNICODE": 0xe12020
CONTEXT: COPY country, line 5, column namespanish:
"Canad?"
Hmm. The sequence looks like latin1 interpreted as utf8. This seem
On Sat, Mar 19, 2005 at 05:25:46PM -0500, Carlos Moreno wrote:
Carlos,
> The error reads like:
>
> psql:db_backup.sql:1548: ERROR: invalid byte sequence for encoding
> "UNICODE": 0xe12020
> CONTEXT: COPY country, line 5, column namespanish:
> "Canad?"
Hmm. The seque
Hello,
I'm trying to upgrade a system that is currently running version 7.4.5
to the new 8.0.1
I create a backup, using pg_dump, and I expect it to work when
restoring it to 8.0.1.
However, when I run:
psql -U user -f backup.sql
Whenever there is a field value that contains characters with accents
