| From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
|---|---|
| To: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: What's a good default encoding? |
| Date: | 2006-03-16 09:09:25 |
| Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCEA3513C@algol.sollentuna.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > Maybe we could even "suggest" UTF8 in the "getting started"
> (i.e. the
> > windows installer initdb screen, or other default
> installations) Sth.
> > like "if you do not know better, take utf8"
>
> UTF-8 on windows works pretty well.
It does, but it has an extra speed penalty. For any comparison operation
(which means sort), the string must be converted to UTF-16, compared,
discarded. Win32 can't do native comparisions in UTF-8. Thoguh I
haven't specifically measured the difference, I doubt it would be
unnoticable. Which is the mani reason we didn't go with it as the
default for the 8.1 installer.
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2006-03-16 09:24:34 | Re: PostgreSQL on Windows not starting |
| Previous Message | Michael Meskes | 2006-03-16 08:42:32 | Re: Fw: ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax error at or near "RELEASE" |