Re: BUG #3394: Partial search not working

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.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

Murali Doss wrote:
> Hi Michael,
>=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.
>=20
> SELECT * FROM tablename WHERE colname BETWEEN 'B' AND 'B~';
>=20
>=20
> Any query to find the local settings and encoding.
>=20

Try

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

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

SHOW client_encoding and SHOW server_encoding

=09
        Zdenek