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: "Douglas Toltzman" <doug(at)oakstreetsoftware(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3394: Partial search not working
Date: 2007-06-19 13:34:51
Message-ID: 7C83A8A6B56D3A478333B1DF47E18586B9312D@mpbabgex01.corp.mphasis.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I have created new database with encoding as sql_ascii and reloaded the
data but still its returning 0 rows in Linux.

 

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

 

 

________________________________

From: Douglas Toltzman [mailto:doug(at)oakstreetsoftware(dot)com] 
Sent: Tuesday, June 19, 2007 6:44 PM
To: Murali Doss
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #3394: Partial search not working

 

AFAIK, you will need to recreate the database.  See "CREATE DATABASE"
command for details, but something like "CREATE DATABASE FOO WITH
ENCODING 'SQL_ASCII'" should do it... if my memory serves me.

 

Of course, you'll need to dump and reload your data.

 

On Jun 19, 2007, at 8:51 AM, Murali Doss wrote:





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

 

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

 

               http://www.postgresql.org/docs/faq

 

Douglas Toltzman

doug(at)oakstreetsoftware(dot)com

(910) 526-5938

 





 

In response to

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2007-06-19 13:59:34
Subject: Re: BUG #3394: Partial search not working
Previous:From: Douglas ToltzmanDate: 2007-06-19 13:14:18
Subject: Re: BUG #3394: Partial search not working

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