Defining character sets for indicidual fields - Mailing list pgsql-general

From Ram Ravichandran
Subject Defining character sets for indicidual fields
Date
Msg-id c8cd6fbb0805311822m29e49617ue561b137cfaa3db3@mail.gmail.com
Whole thread Raw
Responses Re: Defining character sets for indicidual fields
List 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

pgsql-general by date:

Previous
From: "Martin"
Date:
Subject: Re: Converting empty input strings to Nulls
Next
From: Steve Atkins
Date:
Subject: Re: Defining character sets for indicidual fields