lc_ctype does not work on windows ?

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: lc_ctype does not work on windows ?
Date: 2010-04-27 13:30:11
Message-ID: g2q92869e661004270630i4b9fb981x500d21b042378f48@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I have a problem with locale on windows.
postgresql 8.4.

this does not work as expected:

filip=# select 'A' ~ '\w', 'Ą' ~ '\w';
?column? | ?column?
----------+----------
t | f
(1 row)

-- investigating postgres settings:
filip=# select name, setting, context, source, boot_val, reset_val
from pg_settings where name ~*
'(lc|encoding|locale|char|text|version)';
name | setting | context |
source | boot_val | reset_val
----------------------------+-------------------+-----------+--------------------+-------------------+-------------------
client_encoding | win1250 | user | session
| SQL_ASCII | UTF8
default_text_search_config | pg_catalog.simple | user |
configuration file | pg_catalog.simple | pg_catalog.simple
lc_collate | Polish, Poland | internal | override
| C | Polish, Poland
lc_ctype | Polish, Poland | internal | override
| C | Polish, Poland
lc_messages | Polish, Poland | superuser |
configuration file | | Polish, Poland
lc_monetary | Polish, Poland | user |
configuration file | C | Polish, Poland
lc_numeric | Polish, Poland | user |
configuration file | C | Polish, Poland
lc_time | Polish, Poland | user |
configuration file | C | Polish, Poland
server_encoding | UTF8 | internal | override
| SQL_ASCII | UTF8
server_version | 8.4.2 | internal | default
| 8.4.2 | 8.4.2
server_version_num | 80402 | internal | default
| 80402 | 80402
(11 rows)

-- and database settings:
filip=# select * from pg_database where datname='filip';
-[ RECORD 1 ]-+---------------
datname | filip
datdba | 2650623
encoding | 6
datcollate | Polish, Poland
datctype | Polish, Poland
datistemplate | f
datallowconn | t
datconnlimit | -1
datlastsysoid | 11563
datfrozenxid | 649
dattablespace | 1663
datconfig |
datacl |

--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-04-27 14:25:47 Re: lc_ctype does not work on windows ?
Previous Message Alban Hertroys 2010-04-27 13:21:43 Re: PostgreSQL Performance issue