Re: help: collation support on Windows

On Fri, Feb 25, 2011 at 9:54 PM, Andrew Dunstan <andrew(at)dunslane(dot)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.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company