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 4: Have you searched our list archives?
http://archives.postgresql.org
