Defining character sets for indicidual fields

From: "Ram Ravichandran" <ramkaka(at)gmail(dot)com>
To: "pgsql-general General" <pgsql-general(at)postgresql(dot)org>
Subject: Defining character sets for indicidual fields
Date: 2008-06-01 01:22:56
Message-ID: c8cd6fbb0805311822m29e49617ue561b137cfaa3db3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

By default, my postgresql server is set to use UTF8 character set. I was
wondering if there is any way to make sure that certain fields like url etc.
only makes use of ascii. My main aim is to save space by using only 1 byte /
character for urls (some of the urls are over 200 characters long). Is this
possible? Or are all characters eventually converted to UTF8 during storage?

Thanks,

Ram

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2008-06-01 01:34:11 Re: Defining character sets for indicidual fields
Previous Message Martin 2008-06-01 00:57:59 Re: Converting empty input strings to Nulls