Re: locales and encodings on Windows

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: locales and encodings on Windows
Дата
Msg-id 41C9BE8E.2090908@pse-consulting.de
обсуждение исходный текст
Ответ на Re: locales and encodings on Windows  ("Magnus Hagander" <mha@sollentuna.net>)
Список pgsql-hackers-win32
Magnus Hagander wrote:
>
> The implementation is not buggy.
> The implementation of strcoll() etc *does not exist* for UTF-8.
> There is a perfectly working Unicode system on Windows - it has been
> there since Windows NT 3.1. *Every* API in Windows is unicode
> internally. With Unicode in this case, MS means UTF-16.
> How do other programs do? They convert their strings to UTF-16 and use
> the unicode functions in the OS. UTF8 support only exists in the two
> functinos used to convert to/from UTF-16.

In general I agree. Most programs won't use UTF-8 at all, but will work
with wchar_t (i.e. UTF-16 or UTF-32) since coding is easier, and will
convert to UTF-8 on interfaces only. Additionally, storing UTF-8 seems
uncommon to me too; this is usually done using NVARCHAR.


> That's at least how I understand it. I'm not a locale/encoding expert
> though, so I could be wrong :)
>
> Perhaps an emulation layer could be written for port/win32. I can't
> really say, because I don't know these things well enough (on any
> platform).

Shouldn't be too complicated.

Regards,
Andreas

В списке pgsql-hackers-win32 по дате отправления:

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: locales and encodings on Windows
Следующее
От: "Korea PostgreSQL Users' Group"
Дата:
Сообщение: bug plpython compile error for win32