Hi,
Output of pg_setting in Linux OS
"lc_collate";"C"
"lc_ctype";"C"
"lc_messages";"C"
"lc_monetary";"C"
"lc_numeric";"C"
"lc_time";"C"
Client Encoding
"SQL_ASCII"
Server Encoding
"SQL_ASCII"
And it's same in Solaris and Window OS where the query is returning expected
results.
Regards
Mura
"Murali Doss" <[EMAIL PROTECTED]> writes:
> I have created new database with encoding as sql_ascii and reloaded the
> data but still its returning 0 rows in Linux.
It's locale, not encoding (or not only encoding) that determines sort
order. It sounds to me like you are using C locale on the other
Murali Doss wrote:
> I have created new database with encoding as sql_ascii and reloaded the
> data but still its returning 0 rows in Linux.
>
> SELECT * FROM tablename WHERE colname BETWEEN 'B' AND 'B~';
You probably didn't set the appropriate collation, which is the thing
that affects this type
I have created new database with encoding as sql_ascii and reloaded the
data but still its returning 0 rows in Linux.
SELECT * FROM tablename WHERE colname BETWEEN 'B' AND 'B~';
From: Douglas Toltzman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 20
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
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
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 f
Hello Sir,
I am restoring backup from the dump file created using pg_dump.
I restoring the backup I have this error
ERROR: permission denied for schema pg_catalog
ERROR: relation "test33" already exists
Please help me what I have done wrong
Best Regards
Pierce
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 setting
On Tue, Jun 19, 2007 at 02:55:07PM +0530, Murali Doss wrote:
> No result but the matching data is available in table
What values are not matching that you expect to match? Can you
provide a reproducible test case? What are your locale settings
and encoding?
--
Michael Fuhr
---
No result but the matching data is available in table
-Original Message-
From: Heikki Linnakangas [mailto:[EMAIL PROTECTED] On Behalf Of Heikki
Linnakangas
Sent: Tuesday, June 19, 2007 1:17 PM
To: Murali Doss
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #3394: Partial search not w
On Tue, Jun 19, 2007 at 09:43:14AM +, Murali Doss wrote:
> Bug reference: 3395
> Logged by: Murali Doss
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.2.4
> Operating system: Window XP
> Description:varchar[] --> Warning vendor specific
> Details:
>
>
The following bug has been logged online:
Bug reference: 3395
Logged by: Murali Doss
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Window XP
Description:varchar[] --> Warning vendor specific
Details:
In postgresql ,i am using varchar[]
Murali Doss wrote:
The following bug has been logged online:
Bug reference: 3394
Logged by: Murali Doss
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux
Description:Partial search not working
Details:
Dear All,
Partial search que
Murali Doss wrote:
Partial search query is not working Linux OS with postgresql 8.2.4 but the
same is working fine in windows and solaris OS.
I like to know whether i need to run some patch in linux OS to make the
partial search to work.
SELECT * FROM tablename WHERE colname BETWEEN 'B-' AND 'B
The following bug has been logged online:
Bug reference: 3394
Logged by: Murali Doss
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Linux
Description:Partial search not working
Details:
Dear All,
Partial search query is not working Lin
16 matches
Mail list logo
