Re: Unicode comment on Postgres vs Sql Server

From: "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Unicode comment on Postgres vs Sql Server
Date: 2008-03-02 20:32:05
Message-ID: 200803022132.05931.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2008-03-02 20:44:24 Re: Unicode comment on Postgres vs Sql Server
Previous Message Stephane Bortzmeyer 2008-03-02 20:29:39 Re: Unicode comment on Postgres vs Sql Server