Re: case insensitive sorting & searching in oracle 10g - Mailing list pgsql-general

From David Garamond
Subject Re: case insensitive sorting & searching in oracle 10g
Date
Msg-id 41135978.90200@zara.6.isreserved.com
Whole thread Raw
In response to Re: case insensitive sorting & searching in oracle 10g  (David Garamond <lists@zara.6.isreserved.com>)
List pgsql-general
David Garamond wrote:
> 2a. individual string values will be tagged with charset+encoding. this
> incurs an overhead of 1-2 bytes per value.

forgot to add: this overhead is just for "in-memory" or temporary value
(e.g. when being passed as arguments). in the storage itself, this is
not needed because charset+encoding is recorded in the column definition.

--
dave


pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Re: case insensitive sorting & searching in oracle 10g
Next
From: jseymour@linxnet.com (Jim Seymour)
Date:
Subject: Re: Where are all the users?