Re: help: collation support on Windows

On Fri, Feb 25, 2011 at 22:58, Dave Page <dpage@pgadmin.org> wrote:
> On Fri, Feb 25, 2011 at 9:54 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
>>
>>
>> On 02/25/2011 02:32 PM, Peter Eisentraut wrote:
>>>
>>> According to the online documentation, the APIs are there:
>>> http://msdn.microsoft.com/en-ca/library/a7cwbx4t.aspx
>>>
>>> Now we'd need someone brave try to make it work.  The starting point
>>> would be to define HAVE_LOCALE_T and then make it build.  Microsoft has
>>> all the relevant functions and types with an underscore in front
>>> (_strcoll_l, etc.), so some extra #defining will probably be necessary.
>>>
>>> Also, initdb will need to be patched to get a list of OS locales to
>>> populate the pg_collation catalog with.
>>>
>>> Finally, a regression test customized for Windows, but I can help with
>>> that later.
>>>
>>>
>>>
>>
>>
>> What is the equivalent of "locale -a"?
>
> There isn't a command that I know of, but the API function you
> probably need is EnumSystemLocales.

Yeah. If you want example code, you can probably lift something from
the old pginstaller project on pgfoundry - we use that code to
populate the dropdown box for initdb there.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/