Re: [GENERAL] Encoding-related errors when moving from 7.3 to 8.0.1

[...] 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

Re: [GENERAL] Encoding-related errors when moving from 7.3 to 8.0.1

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 search

Re: [GENERAL] Encoding-related errors when moving from 7.3 to 8.0.1

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 perhaps

Re: [GENERAL] Encoding-related errors when moving from 7.3 to 8.0.1

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 the

Re: [GENERAL] Encoding-related errors when moving from 7.3 to 8.0.1

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

Re: [GENERAL] Encoding-related errors when moving from 7.3 to 8.0.1

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 seems

[GENERAL] Encoding-related errors when moving from 7.3 to 8.0.1

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

Re: [GENERAL] Encoding-related errors when moving from 7.3 to 8.0.1

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 sequence looks