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