Re: [GENERAL] utf8 errors

2013-06-28 Thread Vincent Veyron
Le vendredi 28 juin 2013 à 08:15 +0200, Pavel Stehule a écrit : > there is a same issues in perl dbi driver with UTF8 strings - it does > some artificial intelligence and try to do some utf transformations. > Hi Pavel, I glanced over it, but dismissed it as the problem also appeared in my ssh s

Re: [GENERAL] utf8 errors

2013-06-28 Thread Jiří Pavlovský
On 28.6.2013 9:09, Alban Hertroys wrote: > On Jun 26, 2013, at 16:58, Alban Hertroys wrote: > >> On 26 June 2013 11:03, Jiří Pavlovský wrote: >> On 26.6.2013 10:58, Albe Laurenz wrote: >>> Jirí Pavlovský wrote: I have a win32 application. LOG: statement: INSERT INTO recipients (DealID

Re: [GENERAL] utf8 errors

2013-06-28 Thread Alban Hertroys
On Jun 26, 2013, at 16:58, Alban Hertroys wrote: > On 26 June 2013 11:03, Jiří Pavlovský wrote: > On 26.6.2013 10:58, Albe Laurenz wrote: > > Jirí Pavlovský wrote: > >> I have a win32 application. > >> LOG: statement: INSERT INTO recipients (DealID, > >> Contactid)

Re: [GENERAL] utf8 errors

2013-06-27 Thread Alban Hertroys
On Jun 28, 2013, at 8:10, Vincent Veyron wrote: > Hi, > > FYI, I had the exact same problem earlier this week, while building a > new Debian Stable (Wheezy) server where postgresql version is 9.1.9-1 > for a database containing accented characters. You probably had a rather different problem,

Re: [GENERAL] utf8 errors

2013-06-27 Thread Vincent Veyron
I forgot to mention that the machines use an amd64 processor. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] utf8 errors

2013-06-27 Thread Pavel Stehule
Hello 2013/6/28 Vincent Veyron : > Hi, > > FYI, I had the exact same problem earlier this week, while building a > new Debian Stable (Wheezy) server where postgresql version is 9.1.9-1 > for a database containing accented characters. > > Steps where : > pg_dump of a database encoded in LATIN9 on t

Re: [GENERAL] utf8 errors

2013-06-27 Thread Vincent Veyron
Hi, FYI, I had the exact same problem earlier this week, while building a new Debian Stable (Wheezy) server where postgresql version is 9.1.9-1 for a database containing accented characters. Steps where : pg_dump of a database encoded in LATIN9 on the old machine which uses the fr_FR@euro locale

Re: [GENERAL] utf8 errors

2013-06-26 Thread Alban Hertroys
On 26 June 2013 11:03, Jiří Pavlovský wrote: > On 26.6.2013 10:58, Albe Laurenz wrote: > > Jirí Pavlovský wrote: > >> I have a win32 application. > >> LOG: statement: INSERT INTO recipients (DealID, > >> Contactid) VALUES (29009, 9387) > >> ERROR: invalid byte se

Re: [GENERAL] utf8 errors

2013-06-26 Thread Jiří Pavlovský
On 26.6.2013 10:58, Albe Laurenz wrote: > Jirí Pavlovský wrote: >> I have a win32 application. >> LOG: statement: INSERT INTO recipients (DealID, >> Contactid) VALUES (29009, 9387) >> ERROR: invalid byte sequence for encoding "UTF8": 0x9c >> >> >> But the query is

Re: [GENERAL] utf8 errors

2013-06-26 Thread Tom Lane
Albe Laurenz writes: > Once you can reproduce the problem, try a network trace on the communication > between cleint and server. Maybe that helps to solve the problem. Actually, if you can reproduce the problem on demand, try attaching to the backend process with gdb and setting a breakpoint at

Re: [GENERAL] utf8 errors

2013-06-26 Thread Albe Laurenz
Jirí Pavlovský wrote: >>> I'm getting these errors on tables as >>> well. Actually when I copy and paste the offending queries from log into >>> pgAdmin it runs without an >>> error. >> So the queries work from pgadmin; what application/environment are they NOT >> working in? >> Something is obv

Re: [GENERAL] utf8 errors

2013-06-26 Thread Jiří Pavlovský
On 26.6.2013 13:32, Alban Hertroys wrote: > On 26 June 2013 12:39, Jiří Pavlovský > wrote: > > On 26.6.2013 12:19, Alban Hertroys wrote: >> On 26 June 2013 11:17, Jiří Pavlovský > > wrote: >> >> On 26.6.2013 10:58, Albe Lauren

Re: [GENERAL] utf8 errors

2013-06-26 Thread Alban Hertroys
On 26 June 2013 12:39, Jiří Pavlovský wrote: > On 26.6.2013 12:19, Alban Hertroys wrote: > > On 26 June 2013 11:17, Jiří Pavlovský wrote: > >> On 26.6.2013 10:58, Albe Laurenz wrote: >> > Jirí Pavlovský wrote: >> >> I have a win32 application. >> >> LOG: statement: INSERT INTO recipients (De

Re: [GENERAL] utf8 errors

2013-06-26 Thread Jiří Pavlovský
On 26.6.2013 12:19, Alban Hertroys wrote: > On 26 June 2013 11:17, Jiří Pavlovský > wrote: > > On 26.6.2013 10:58, Albe Laurenz wrote: > > Jirí Pavlovský wrote: > >> I have a win32 application. > >> LOG: statement: INSERT INTO recipients (DealID, > >

Re: [GENERAL] utf8 errors

2013-06-26 Thread Alban Hertroys
On 26 June 2013 11:17, Jiří Pavlovský wrote: > On 26.6.2013 10:58, Albe Laurenz wrote: > > Jirí Pavlovský wrote: > >> I have a win32 application. > >> LOG: statement: INSERT INTO recipients (DealID, > >> Contactid) VALUES (29009, 9387) > >> ERROR: invalid byte se

Re: [GENERAL] utf8 errors

2013-06-26 Thread Jiří Pavlovský
On 26.6.2013 10:58, Albe Laurenz wrote: > Jirí Pavlovský wrote: >> I have a win32 application. >> LOG: statement: INSERT INTO recipients (DealID, >> Contactid) VALUES (29009, 9387) >> ERROR: invalid byte sequence for encoding "UTF8": 0x9c >> >> >> But the query is

Re: [GENERAL] utf8 errors

2013-06-26 Thread Jiří Pavlovský
On 26.6.2013 10:58, Albe Laurenz wrote: > Jirí Pavlovský wrote: >> I have a win32 application. >> LOG: statement: INSERT INTO recipients (DealID, >> Contactid) VALUES (29009, 9387) >> ERROR: invalid byte sequence for encoding "UTF8": 0x9c >> >> >> But the query is

Re: [GENERAL] utf8 errors

2013-06-26 Thread Albe Laurenz
Jirí Pavlovský wrote: > I have a win32 application. > LOG: statement: INSERT INTO recipients (DealID, > Contactid) VALUES (29009, 9387) > ERROR: invalid byte sequence for encoding "UTF8": 0x9c > > > But the query is clean ascii and it doesn't even contain the me

Re: [GENERAL] utf8 errors

2013-06-25 Thread Pavel Stehule
2013/6/25 Jiří Pavlovský : > On 25.6.2013 21:39, Pavel Stehule wrote: >> Hello >> >> in this mailing list is not high traffic, >> >> please try to ask on postgresql general mailing list >> >> http://www.postgresql.org/list/pgsql-general/ >> >> or >> >> Czech google groups >> https://groups.google.

Re: [GENERAL] utf8 errors

2013-06-25 Thread Jiří Pavlovský
On 25.6.2013 21:39, Pavel Stehule wrote: > Hello > > in this mailing list is not high traffic, > > please try to ask on postgresql general mailing list > > http://www.postgresql.org/list/pgsql-general/ > > or > > Czech google groups > https://groups.google.com/forum/?hl=cs#!forum/postgresql-cz > >

Re: [GENERAL] utf8 errors

2013-06-25 Thread Pavel Stehule
Hello in this mailing list is not high traffic, please try to ask on postgresql general mailing list http://www.postgresql.org/list/pgsql-general/ or Czech google groups https://groups.google.com/forum/?hl=cs#!forum/postgresql-cz 2013/6/25 Jiří Pavlovský : > Hello, > > I have a win32 applicat

Re: [GENERAL] utf8 errors

2013-06-25 Thread Adrian Klaver
On 06/25/2013 12:18 PM, Jiří Pavlovský wrote: Hello, I have a win32 application. It uses gtk for GUI and postgres. Recently I upgraded to newer gtk and postgres 9.2. I'm now getting utf8 errors from postgres. The thing I don't understand that the queries, which postgres complains about, seem to

[GENERAL] utf8 errors

2013-06-25 Thread Jiří Pavlovský
Hello, I have a win32 application. It uses gtk for GUI and postgres. Recently I upgraded to newer gtk and postgres 9.2. I'm now getting utf8 errors from postgres. The thing I don't understand that the queries, which postgres complains about, seem to be perfectly valid. For example LOG: statemen