Re: BUG #3394: Partial search not working

I have created new database with encoding as sql_ascii and reloaded the
data but still its returning 0 rows in Linux.

=20

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

=20

=20

________________________________

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

=20

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.

=20

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

=20

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





Hi Zdenek,

=20

Thanks for your effort.

=20

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?

=20

Regards

Murali Doss T.S.

=20

=20

=20

-----Original Message-----

From: Zdenek.Kotala@Sun.COM [mailto:Zdenek.Kotala@Sun.COM]=20

Sent: Tuesday, June 19, 2007 5:31 PM

To: Murali Doss

Cc: Michael Fuhr; Heikki Linnakangas; pgsql-bugs@postgresql.org

Subject: Re: [BUGS] BUG #3394: Partial search not working

=20

Murali Doss wrote:

    Hi Michael,

=09=20

    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.

=09=20

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

=09=20

=09=20

    Any query to find the local settings and encoding.

=09=20

=20

Try

=20

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

=20

The psql -l command shows you database encoding. Client and server=20

encoding is possible get by the following commands:

=20

SHOW client_encoding and SHOW server_encoding

=20

=20=20=20=20=20=20=20=20=20=20=20=20

                        Zdenek

=20

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

TIP 3: Have you checked our extensive FAQ?

=20

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

=20

Douglas Toltzman

doug@oakstreetsoftware.com

(910) 526-5938

=20





=20