From: | Douglas Toltzman <doug(at)oakstreetsoftware(dot)com> |
---|---|
To: | "Murali Doss" <Murali(dot)Doss(at)mphasis(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3394: Partial search not working |
Date: | 2007-06-19 13:14:18 |
Message-ID: | B856332B-BA5B-403B-BF43-330C1724EBB4@oakstreetsoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
Of course, you'll need to dump and reload your data.
On Jun 19, 2007, at 8:51 AM, Murali Doss wrote:
> 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(dot)Kotala(at)Sun(dot)COM [mailto:Zdenek(dot)Kotala(at)Sun(dot)COM]
> Sent: Tuesday, June 19, 2007 5:31 PM
> To: Murali Doss
> Cc: Michael Fuhr; Heikki Linnakangas; pgsql-bugs(at)postgresql(dot)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
Douglas Toltzman
doug(at)oakstreetsoftware(dot)com
(910) 526-5938
From | Date | Subject | |
---|---|---|---|
Next Message | Murali Doss | 2007-06-19 13:34:51 | Re: BUG #3394: Partial search not working |
Previous Message | Murali Doss | 2007-06-19 12:51:19 | Re: BUG #3394: Partial search not working |