Re: case insensitive sorting & searching in oracle 10g

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To:
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: case insensitive sorting & searching in oracle 10g
Date: 2004-08-06 10:12:08
Message-ID: 41135978.90200@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Seymour 2004-08-06 11:06:54 Re: Where are all the users?
Previous Message David Garamond 2004-08-06 10:03:40 Re: case insensitive sorting & searching in oracle 10g