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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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, > > 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 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
