Re: [BUGS] Win1250 database under linux

2005-04-30 Thread Tom Lane
Damir Bijuklic <[EMAIL PROTECTED]> writes: > My linux machine has following relevant locales: > hr_HR > hr_HR.iso88592 > hr_HR.utf8 > hrvatski I'd recommend using hr_HR.utf8 plus UTF8 database encoding. You'll need to re-initdb in order to install that as the database locale :-(

Re: [BUGS] Win1250 database under linux

2005-04-30 Thread Tom Lane
Damir Bijuklic <[EMAIL PROTECTED]> writes: > I'm using WIN1250 locale on both databases. Does your Linux platform even have such a locale? Mine doesn't. ("locale -a" will show you what is supported.) I suspect your machine is not recognizing the LANG setting and is falling back to behave as thou

Re: [BUGS] Win1250 database under linux

2005-04-29 Thread Tom Lane
Damir Bijuklic <[EMAIL PROTECTED]> writes: > The problem i'm having seems to be known but i don't > know if there is a workaround. Functions upper() and > lower() don't change value for Croatian national > characters under linux (others probably as well, but i > havent tested). Operator ILIKE doesn

[BUGS] Win1250 database under linux

2005-04-29 Thread Damir Bijuklic
Hi. I have ecountered strange behaviour with postgres 8 under linux so I am reporting this as a bug. I haven't compiled postgres myself because it is on hosted server but it is an options if it would solve this problem. The problem i'm having seems to be known but i don't know if there is a worka