[HACKERS] Encoding problem

2006-11-02 Thread Hiroshi Saito
Hi. I have some encoding problems. 1.) Expression of output of log of server http://inet.winpg.jp/~saito/pg_bug/postgresql-2006-11-02_192633.log This is not in the output for the translation by GetText and is ..Native.. message. (Japanese windows--Shift_jis message) 2.) The message makes a m

Re: [HACKERS] Encoding problem with 7.4

2003-12-04 Thread Stephan Szabo
On Thu, 4 Dec 2003, E.Rodichev wrote: > On Wed, 3 Dec 2003, Stephan Szabo wrote: > > > The locale settings depend on LC_* at initdb time only. When the > > postmaster starts it sets the locale based on the stored values from > > initdb, not on the current environment. > > > > With an SQL_ASCII da

Re: [HACKERS] Encoding problem with 7.4

2003-12-04 Thread Andrew Dunstan
E.Rodichev wrote: On Wed, 3 Dec 2003, Stephan Szabo wrote: The locale settings depend on LC_* at initdb time only. When the postmaster starts it sets the locale based on the stored values from initdb, not on the current environment. With an SQL_ASCII database being accessed from a client with

Re: [HACKERS] Encoding problem with 7.4

2003-12-04 Thread E.Rodichev
On Wed, 3 Dec 2003, Stephan Szabo wrote: > The locale settings depend on LC_* at initdb time only. When the > postmaster starts it sets the locale based on the stored values from > initdb, not on the current environment. > > With an SQL_ASCII database being accessed from a client with > client_enc

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread Stephan Szabo
On Thu, 4 Dec 2003, E.Rodichev wrote: > On Wed, 3 Dec 2003, Stephan Szabo wrote: > > > Only the locale settings at initdb time matter. Changing the LC_* later > > is not going to change what the database does. Encoding and locale are > > separate (but related) and it is your responsibility to ma

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread E.Rodichev
On Wed, 3 Dec 2003, Stephan Szabo wrote: > Only the locale settings at initdb time matter. Changing the LC_* later > is not going to change what the database does. Encoding and locale are > separate (but related) and it is your responsibility to make sure the > choices are consistent. If you do

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread E.Rodichev
On Wed, 3 Dec 2003, Andrew Dunstan wrote: > Encoding and collation order are two different things. LC_* settings > have no effect on encoding. > > see http://www.postgresql.org/docs/current/static/charset.html I am trying to point out to reverse dependency: encoding (1) has effect on LC_* settin

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread E.Rodichev
On Wed, 3 Dec 2003, Alvaro Herrera wrote: > On Wed, Dec 03, 2003 at 11:42:34PM +0300, E.Rodichev wrote: > > On Wed, 3 Dec 2003, Stephan Szabo wrote: > > > > > No, it isn't. As far as PostgreSQL is concerned the database is SQL_ASCII > > > since you didn't override the default encoding at initdb ti

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread Stephan Szabo
On Wed, 3 Dec 2003, E.Rodichev wrote: > On Wed, 3 Dec 2003, Stephan Szabo wrote: > > > > > On Wed, 3 Dec 2003, E.Rodichev wrote: > > > > > On Fri, 28 Nov 2003, Tom Lane wrote: > > > > > > > "E.Rodichev" <[EMAIL PROTECTED]> writes: > > > > > /e:2>createdb test > > > > > > > > > test | er

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread Alvaro Herrera
On Wed, Dec 03, 2003 at 11:42:34PM +0300, E.Rodichev wrote: > On Wed, 3 Dec 2003, Stephan Szabo wrote: > > > No, it isn't. As far as PostgreSQL is concerned the database is SQL_ASCII > > since you didn't override the default encoding at initdb time or at > > createdb time. You did choose LC_ valu

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread Andrew Dunstan
E.Rodichev wrote: On Wed, 3 Dec 2003, Stephan Szabo wrote: On Wed, 3 Dec 2003, E.Rodichev wrote: On Fri, 28 Nov 2003, Tom Lane wrote: "E.Rodichev" <[EMAIL PROTECTED]> writes: /e:2>createdb test test | er | SQL_ASCII <- Incorrect! (3 rows)

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread E.Rodichev
On Wed, 3 Dec 2003, Stephan Szabo wrote: > > On Wed, 3 Dec 2003, E.Rodichev wrote: > > > On Fri, 28 Nov 2003, Tom Lane wrote: > > > > > "E.Rodichev" <[EMAIL PROTECTED]> writes: > > > > /e:2>createdb test > > > > > > > test | er | SQL_ASCII <- Incorrect! > > > > (3 rows) > > > > >

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread Stephan Szabo
On Wed, 3 Dec 2003, E.Rodichev wrote: > On Fri, 28 Nov 2003, Tom Lane wrote: > > > "E.Rodichev" <[EMAIL PROTECTED]> writes: > > > /e:2>createdb test > > > > > test | er | SQL_ASCII <- Incorrect! > > > (3 rows) > > > > > Let's note than the last line is in fact completely incorre

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread Andrew Dunstan
E.Rodichev wrote: On Fri, 28 Nov 2003, Tom Lane wrote: "E.Rodichev" <[EMAIL PROTECTED]> writes: /e:2>createdb test test | er | SQL_ASCII <- Incorrect! (3 rows) Let's note than the last line is in fact completely incorrect. What's incorrect about it?

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread Peter Eisentraut
E.Rodichev writes: > It is incorrect, because database "test" is, really, in KOI8, NOT in SQL_ASCII > in this example, as I explained in my mail. The encoding is only a declaration of your intentions. What you actually put into the database is your responsibility. -- Peter Eisentraut [EMAIL

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread E.Rodichev
On Fri, 28 Nov 2003, Tom Lane wrote: > "E.Rodichev" <[EMAIL PROTECTED]> writes: > > /e:2>createdb test > > > test | er | SQL_ASCII <- Incorrect! > > (3 rows) > > > Let's note than the last line is in fact completely incorrect. > > What's incorrect about it? You didn't ask for an

Re: [HACKERS] Encoding problem with 7.4

2003-11-28 Thread Tom Lane
"E.Rodichev" <[EMAIL PROTECTED]> writes: > /e:2>createdb test > test | er | SQL_ASCII <- Incorrect! > (3 rows) > Let's note than the last line is in fact completely incorrect. What's incorrect about it? You didn't ask for any other encoding than SQL_ASCII. You can set the def

Re: [HACKERS] Encoding problem with 7.4

2003-11-27 Thread Christopher Kings-Lynne
After installing 7.4 I created database completely from scratch with cyrillic locale: su postgres export LC_CTYPE=ru_RU.KOI8-R export LC_COLLATE=ru_RU.KOI8-R /usr/local/pgsql/bin/initdb -D /db2/pgdata You need to go: /usr/local/pgsql/bin/initdb -D /db2/pgdata -E KOI8 To set the default encoding t

Re: [HACKERS] Encoding problem with 7.4

2003-11-27 Thread Jean-Michel POURE
Le Jeudi 27 Novembre 2003 20:56, E.Rodichev a écrit : > After installing 7.4 I created database completely from scratch > with cyrillic locale: Dear Evgeny, If you want to go 'fast', do not hesitate to install pgAdmin3 GUI from http://www.pgadmin.org. We will be able to create and manage a databa

Re: [HACKERS] Encoding problem with 7.4

2003-11-27 Thread Peter Eisentraut
E.Rodichev writes: > I just noticed some incorrect behaviour for postgresql-7.4 related > to locale. Maybe you should first read the documentation to understand how it actually works. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)

[HACKERS] Encoding problem with 7.4

2003-11-27 Thread E.Rodichev
Hi, I just noticed some incorrect behaviour for postgresql-7.4 related to locale. After installing 7.4 I created database completely from scratch with cyrillic locale: su postgres export LC_CTYPE=ru_RU.KOI8-R export LC_COLLATE=ru_RU.KOI8-R /usr/local/pgsql/bin/initdb -D /db2/pgdata /usr/local/pg

Re: [HACKERS] encoding problem

2002-06-27 Thread Tom Lane
"Fouad Fezzi" <[EMAIL PROTECTED]> writes: > i just upgrading postgres from 7.0 to 7.2 and i have the folowing error in > configuration process > what happen ? how to fix this problem ? > Enter default encoding (SQL_ASCII): > Now installing the PostgreSQL database files in /var/lib/postgres/data >

[HACKERS] encoding problem

2002-06-27 Thread Fouad Fezzi
Hi i just upgrading postgres from 7.0 to 7.2 and i have the folowing error in configuration process what happen ? how to fix this problem ? Enter default encoding (SQL_ASCII): Now installing the PostgreSQL database files in /var/lib/postgres/data su - postgres -c cd /var/lib/postgres; . ./.profil