Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> On Wed, 2006-09-27 at 14:58 -0400, Tom Lane wrote:
>> LANG=en_US locale charmap
> The working machine says: ISO-8859-1
> The not working machine says: ISO-8859-1
OK, so the problem is that you have a locale that expects ISO-8859-1
encoding, but the
Hi Tom,
Thanks for putting up with the questions.
On Wed, 2006-09-27 at 14:58 -0400, Tom Lane wrote:
> LANG=en_US locale charmap
>
I have done this on both machines:
The working machine says: ISO-8859-1
The not working machine says: ISO-8859-1
I still do not understand what is happening and ma
Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> On Wed, 2006-09-27 at 12:10 -0400, Tom Lane wrote:
>> What you need to find out next is
>> what character set encoding that locale implies on your machine. I'm
>> betting it's not utf8 though :-(
> If this is not what you mean, could you help me in
On Wed, 2006-09-27 at 12:10 -0400, Tom Lane wrote:
> Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> > On Wed, 2006-09-27 at 11:00 -0400, Tom Lane wrote:
> >> But have they got the same locale settings (lc_collate, lc_ctype)?
>
> > According to the postgresql.conf of the *working* database the l
Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> On Wed, 2006-09-27 at 11:00 -0400, Tom Lane wrote:
>> But have they got the same locale settings (lc_collate, lc_ctype)?
> According to the postgresql.conf of the *working* database the locales
> are:
> lc_messages = 'C'
> lc_monetary = 'C'
>
Hi Tom,
On Wed, 2006-09-27 at 11:00 -0400, Tom Lane wrote:
> "Joost Kraaijeveld" <[EMAIL PROTECTED]> writes:
> > I have 2 database, both created with:
> > CREATE DATABASE muntdev WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE
> > = pg_default;
>
> But have they got the same locale settings (
"Joost Kraaijeveld" <[EMAIL PROTECTED]> writes:
> I have 2 database, both created with:
> CREATE DATABASE muntdev WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE =
> pg_default;
But have they got the same locale settings (lc_collate, lc_ctype)?
regards, tom lane
-
Hi Joost. (hoe gaat het ermee?)
I would like to test this too. Could you please provide the data you are
inserting into the database.
Regards,
Gevik
On Wed, 2006-09-27 at 13:13 +0200, Joost Kraaijeveld wrote:
> Hi,
>
> I have a strange problem.
>
> I have 2 database, both created with:
> CRE
Hi,
I have a strange problem.
I have 2 database, both created with:
CREATE DATABASE muntdev WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE =
pg_default;
Running the queries below on the first database is OK and do what I expect.
If I create a backup of the first datase and restore that b
