Re: Unicode comment on Postgres vs Sql Server - Mailing list pgsql-general

From Leif B. Kristensen
Subject Re: Unicode comment on Postgres vs Sql Server
Date
Msg-id 200803022132.05931.leif@solumslekt.org
Whole thread Raw
In response to Unicode comment on Postgres vs Sql Server  ("Swaminathan Saikumar" <swami@giveexam.com>)
List pgsql-general
On Sunday 2. March 2008, Swaminathan Saikumar wrote:
>I am using UTF8 Unicode for most of my data, but there is some data
> that I know for sure will be ASCII. However, this is also stored as
> UTF8, using up more space.

ASCII stored as UTF8 doesn't take up more space than plain ASCII, it's
exactly the same thing. It's one byte per character unless the
character number is above 127.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/

pgsql-general by date:

Previous
From: "Swaminathan Saikumar"
Date:
Subject: Re: Unicode comment on Postgres vs Sql Server
Next
From: Karl Denninger
Date:
Subject: Re: 8.2.6 > 8.3 blows up