Re: [GENERAL] Defining character sets for indicidual fields

2008-06-01 Thread Tino Wildenhain
Hi, Steve Atkins wrote: On May 31, 2008, at 6:22 PM, Ram Ravichandran wrote: 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 u

Re: [GENERAL] Defining character sets for indicidual fields

2008-05-31 Thread Steve Atkins
On May 31, 2008, at 6:22 PM, Ram Ravichandran wrote: 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 / char

[GENERAL] Defining character sets for indicidual fields

2008-05-31 Thread Ram Ravichandran
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)