Re: 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