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

Re: BUG #3394: Partial search not working

From: "Murali Doss" <Murali(dot)Doss(at)mphasis(dot)com>
To: <Zdenek(dot)Kotala(at)Sun(dot)COM>
Cc: "Michael Fuhr" <mike(at)fuhr(dot)org>,"Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3394: Partial search not working
Date: 2007-06-19 12:51:19
Message-ID: 7C83A8A6B56D3A478333B1DF47E18586B930EF@mpbabgex01.corp.mphasis.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi Zdenek,

Thanks for your effort.

Database encoding for Solaris OS is SQL_ASCII but it's UTF8 in Linux OS.
How to change the database encoding to sql_ascii for linux OS?

Regards
Murali Doss T.S.



-----Original Message-----
From: Zdenek(dot)Kotala(at)Sun(dot)COM [mailto:Zdenek(dot)Kotala(at)Sun(dot)COM] 
Sent: Tuesday, June 19, 2007 5:31 PM
To: Murali Doss
Cc: Michael Fuhr; Heikki Linnakangas; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #3394: Partial search not working

Murali Doss wrote:
> 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.
> 

Try

SELECT name, setting FROM pg_settings WHERE name LIKE 'lc_%';

The psql -l command shows you database encoding. Client and server 
encoding is possible get by the following commands:

SHOW client_encoding and SHOW server_encoding

	
		Zdenek

In response to

Responses

pgsql-bugs by date

Next:From: Douglas ToltzmanDate: 2007-06-19 13:14:18
Subject: Re: BUG #3394: Partial search not working
Previous:From: Zdenek KotalaDate: 2007-06-19 12:01:18
Subject: Re: BUG #3394: Partial search not working

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