pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedlower and unicode
7+ messages / 3 participants
[nested] [flat]
* lower and unicode
@ 2005-03-14 06:01 pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 08:15 ` Re: lower and unicode Miroslav Šulc <miroslav.sulc@startnet.cz>
0 siblings, 1 reply; 7+ messages in thread
From: pginfo @ 2005-03-14 06:01 UTC (permalink / raw)
To: pgsql-sql
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 where can I find info
about unicode status with pg?
regards,
ivan.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: lower and unicode
2005-03-14 06:01 lower and unicode pginfo <pginfo@t1.unisoftbg.com>
@ 2005-03-14 08:15 ` Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-14 09:40 ` Re: lower and unicode pginfo <pginfo@t1.unisoftbg.com>
0 siblings, 1 reply; 7+ messages in thread
From: Miroslav Šulc @ 2005-03-14 08:15 UTC (permalink / raw)
To: pginfo <pginfo@t1.unisoftbg.com>; +Cc: pgsql-sql
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
pginfo wrote:
> 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 where can I find info
> about unicode status with pg?
>
> regards,
> ivan.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Attachments:
miroslav.sulc.vcf (text/x-vcard, 385B) download
begin:vcard
fn;quoted-printable:Miroslav =C5=A0ulc
n;quoted-printable:=C5=A0ulc;Miroslav
org:StartNet s.r.o.
adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika
email;internet:miroslav.sulc@startnet.cz
title:CEO
tel;work:+420 257 225 602
tel;cell:+420 603 711 413
x-mozilla-html:TRUE
url:http://www.startnet.cz
version:2.1
end:vcard
* Re: lower and unicode
2005-03-14 06:01 lower and unicode pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 08:15 ` Re: lower and unicode Miroslav Šulc <miroslav.sulc@startnet.cz>
@ 2005-03-14 09:40 ` pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 10:43 ` Re: lower and unicode Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-17 16:15 ` Re: lower and unicode Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 7+ messages in thread
From: pginfo @ 2005-03-14 09:40 UTC (permalink / raw)
To: Miroslav Šulc <miroslav.sulc@startnet.cz>; +Cc: pgsql-sql
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, UNICODE (UTF8) is not supported because Windows natively
> supports only UTF16 (I'm just repeating something I have read somewhere).
>
> Miroslav
>
> pginfo wrote:
>
>> 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 where can I find info
>> about unicode status with pg?
>>
>> regards,
>> ivan.
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister command
>> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: lower and unicode
2005-03-14 06:01 lower and unicode pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 08:15 ` Re: lower and unicode Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-14 09:40 ` Re: lower and unicode pginfo <pginfo@t1.unisoftbg.com>
@ 2005-03-14 10:43 ` Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-14 11:50 ` Re: lower and unicode pginfo <pginfo@t1.unisoftbg.com>
1 sibling, 1 reply; 7+ messages in thread
From: Miroslav Šulc @ 2005-03-14 10:43 UTC (permalink / raw)
To: pginfo <pginfo@t1.unisoftbg.com>; +Cc: pgsql-sql
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 database initialized to something else
than xy_XY.utf8 which must be used to have databases working correctly
with UNICODE. Try 'locale -a' and choose your locale that has *.utf8 to
initialize the database. Then things should be O.K. :-)
I don't remember I've seen some note in documentation that users must
use for databases the same encoding as they used for initdb. If this is
true, it would be time saving to mention this in documentation (if it is
not already there).
>
> regards,
> ivan.
Miroslav
Attachments:
miroslav.sulc.vcf (text/x-vcard, 385B) download
begin:vcard
fn;quoted-printable:Miroslav =C5=A0ulc
n;quoted-printable:=C5=A0ulc;Miroslav
org:StartNet s.r.o.
adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika
email;internet:miroslav.sulc@startnet.cz
title:CEO
tel;work:+420 257 225 602
tel;cell:+420 603 711 413
x-mozilla-html:TRUE
url:http://www.startnet.cz
version:2.1
end:vcard
* Re: lower and unicode
2005-03-14 06:01 lower and unicode pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 08:15 ` Re: lower and unicode Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-14 09:40 ` Re: lower and unicode pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 10:43 ` Re: lower and unicode Miroslav Šulc <miroslav.sulc@startnet.cz>
@ 2005-03-14 11:50 ` pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 12:57 ` Re: lower and unicode Miroslav Šulc <miroslav.sulc@startnet.cz>
0 siblings, 1 reply; 7+ messages in thread
From: pginfo @ 2005-03-14 11:50 UTC (permalink / raw)
To: Miroslav Šulc <miroslav.sulc@startnet.cz>; +Cc: pgsql-sql
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 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 database initialized to something
> else than xy_XY.utf8 which must be used to have databases working
> correctly with UNICODE. Try 'locale -a' and choose your locale that
> has *.utf8 to initialize the database. Then things should be O.K. :-)
>
> I don't remember I've seen some note in documentation that users must
> use for databases the same encoding as they used for initdb. If this
> is true, it would be time saving to mention this in documentation (if
> it is not already there).
>
>>
>> regards,
>> ivan.
>
>
> Miroslav
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: lower and unicode
2005-03-14 06:01 lower and unicode pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 08:15 ` Re: lower and unicode Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-14 09:40 ` Re: lower and unicode pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 10:43 ` Re: lower and unicode Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-14 11:50 ` Re: lower and unicode pginfo <pginfo@t1.unisoftbg.com>
@ 2005-03-14 12:57 ` Miroslav Šulc <miroslav.sulc@startnet.cz>
0 siblings, 0 replies; 7+ messages in thread
From: Miroslav Šulc @ 2005-03-14 12:57 UTC (permalink / raw)
To: pginfo <pginfo@t1.unisoftbg.com>; +Cc: pgsql-sql
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 penalty by using cs_CZ.utf8.
When using PostgreSQL, I need correct collating order for strings so I
have no other choice. I didn't do any speed tests but I think if you
need correct behaviour for your locale, you should use your locale. Just
try it and you will see the results. You can then make a decision for
yourself. I think you won't be the only one using locale for your
database ;-)
> regards,
> ivan.
Miroslav
Attachments:
miroslav.sulc.vcf (text/x-vcard, 385B) download
begin:vcard
fn;quoted-printable:Miroslav =C5=A0ulc
n;quoted-printable:=C5=A0ulc;Miroslav
org:StartNet s.r.o.
adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika
email;internet:miroslav.sulc@startnet.cz
title:CEO
tel;work:+420 257 225 602
tel;cell:+420 603 711 413
x-mozilla-html:TRUE
url:http://www.startnet.cz
version:2.1
end:vcard
* Re: lower and unicode
2005-03-14 06:01 lower and unicode pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 08:15 ` Re: lower and unicode Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-14 09:40 ` Re: lower and unicode pginfo <pginfo@t1.unisoftbg.com>
@ 2005-03-17 16:15 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 7+ messages in thread
From: Peter Eisentraut @ 2005-03-17 16:15 UTC (permalink / raw)
To: pginfo <pginfo@t1.unisoftbg.com>; +Cc: Miroslav Šulc <miroslav.sulc@startnet.cz>; pgsql-sql
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/
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2005-03-17 16:15 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-14 06:01 lower and unicode pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 08:15 ` Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-14 09:40 ` pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 10:43 ` Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-14 11:50 ` pginfo <pginfo@t1.unisoftbg.com>
2005-03-14 12:57 ` Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-17 16:15 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox