Re: BUG #3394: Partial search not working

Hi Michael,

Same database dump is there Solaris, Windows and Linux and the partial
search query is displaying the expected results in Solaris and Windows
OS but the query returning 0 row in Linux OS.

SELECT * FROM tablename WHERE colname BETWEEN 'B' AND 'B~';


Any query to find the local settings and encoding.

Regards
Murali Doss T.S.


-----Original Message-----
From: Michael Fuhr [mailto:mike@fuhr.org]=20
Sent: Tuesday, June 19, 2007 3:51 PM
To: Murali Doss
Cc: Heikki Linnakangas; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #3394: Partial search not working

On Tue, Jun 19, 2007 at 02:55:07PM +0530, Murali Doss wrote:
> No result but the matching data is available in table

What values are not matching that you expect to match?  Can you
provide a reproducible test case?  What are your locale settings
and encoding?

--=20
Michael Fuhr