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
