Skip site navigation (1) Skip section navigation (2)

Re: Comparing a varchar of length > 32

From: "Christian Enklaar" <christian(dot)enklaar(at)mbs-software(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Comparing a varchar of length > 32
Date: 2004-09-24 08:35:42
Message-ID: cj0m6e$222h$ (view raw, whole thread or download thread mbox)
Lists: pgsql-general

thanks for your help.

Seems as if the problem was related to our locale settings.

We are running PostgreSQL on QNX and did not set any specific locale when
creating the database.

Now when we explicitely use LOCALE C on database creation everything works

"Christian Enklaar" <christian(dot)enklaar(at)mbs-software(dot)de> schrieb im
Newsbeitrag news:civ5i0$12s4$1(at)news(dot)hub(dot)org(dot)(dot)(dot)
> Hello,
> we are using a table with a primary key of type varchar[50].
> If we try to find entries with select * from <table> where <table.key> =
> '<text>';
> entries with a key length of more than 32 characters are not found.
> Entries with a shorter key are found. Using "Like" instead of "=" works
> varchar keys with length > 32 as well.
> Does anybody know about this Problem ?
> (We use PostgresQL 7.4.1)
> Thanks in advance,
> Christian Enklaar.

In response to

pgsql-general by date

Next:From: Sebastian BöckDate: 2004-09-24 08:41:04
Subject: Re: How do I disable: Adding missing FROM-clause
Previous:From: Karsten HilbertDate: 2004-09-24 07:21:17
Subject: Re: need ``row number``

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group