Re: [SQL] lower and unicode

2005-03-17 Thread Peter Eisentraut
pginfo wrote: > I am uusing pg 8.0.1 on FreeBSD 5.3 but I am ready t use the version > taht supports correct unicode. FreeBSD doesn't support Unicode, so you need to use something else. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)---

Re: [SQL] lower and unicode

2005-03-14 Thread Miroslav Šulc
pginfo wrote: Hi, I am using --no-locale by init db. I readet that if I am using some locale the pg will work very slow. I don't remember reading it will be very slow. I just remember that I've read it will slow down some things (which I think is logical in this case). Have you noticed some speed

Re: [SQL] lower and unicode

2005-03-14 Thread pginfo
Hi, I am using --no-locale by init db. I readet that if I am using some locale the pg will work very slow. Have you noticed some speed penalty by using cs_CZ.utf8. regards, ivan. Miroslav Šulc wrote: pginfo wrote: Hi, I am uusing pg 8.0.1 on FreeBSD 5.3 but I am ready t use the version taht suppor

Re: [SQL] lower and unicode

2005-03-14 Thread Miroslav Šulc
pginfo wrote: Hi, I am uusing pg 8.0.1 on FreeBSD 5.3 but I am ready t use the version taht supports correct unicode. I think that should be fine. I use PostgreSQL 8.0.1 on Linux (Gentoo) without these problems (I used cs_CZ.utf8 to init my db). What you write seems to me that you have your data

Re: [SQL] lower and unicode

2005-03-14 Thread pginfo
Hi, I am uusing pg 8.0.1 on FreeBSD 5.3 but I am ready t use the version taht supports correct unicode. regards, ivan. Miroslav Šulc wrote: Are you using PostgreSQL on Windows? If so, you should read the FAQ here http://pginstaller.projects.postgresql.org/FAQ_windows.html#2.6. On Windows, UNICO

Re: [SQL] lower and unicode

2005-03-14 Thread Miroslav Šulc
Are you using PostgreSQL on Windows? If so, you should read the FAQ here http://pginstaller.projects.postgresql.org/FAQ_windows.html#2.6. On Windows, UNICODE (UTF8) is not supported because Windows natively supports only UTF16 (I'm just repeating something I have read somewhere). Miroslav pginf

[SQL] lower and unicode

2005-03-13 Thread pginfo
Hi , I tested the lower with unicode on 8.0.1 and find it not to work. If I have only latin symbols it is working well, but if I try to use also cyrillic the lower simpli ignore this symbols and all stay as is. I readet that this will work on 8.x . Exists some one using lower/upper + unicode and w