[HACKERS] copy from stdin; bug?

2001-01-14 Thread Rehak Tamas
Hello i don't know, whether it is a real bug or what, has been fixed or not, but i can't find any info about it: i try to fill my table from a file using copy from stdin and postgresql corrupt the table. This happen if before the or end of line there is word that has a non-standard letter like

Re: [HACKERS] copy from stdin; bug?

2001-01-14 Thread Rehak Tamas
Hi On Sun, 14 Jan 2001, Tom Lane wrote: > Sounds to me like a multibyte-character translation problem. What > encoding do you have set for the database? What have you told it the > client encoding is? sorry, i forgot to write: i use debian potato, i use the standard debian packege. version 6.5

Re: [HACKERS] copy from stdin; bug?

2001-01-16 Thread Rehak Tamas
Hello On Mon, 15 Jan 2001, Tatsuo Ishii wrote: > Can you show me your database name and the output from 'psql -l'? yes, here are the output: datname |datdba|encoding|datpath -+--++- template1|31| 5|template1 map

Re: [HACKERS] copy from stdin; bug?

2001-01-17 Thread Rehak Tamas
Re On Tue, 16 Jan 2001, Tatsuo Ishii wrote: > The encoding of your databases are all UNICODE. So you need to input > data as UTF-8 in this case. I guess you are trying to input ISO-8859-1 > encoded data that is the source of the problem. Here are possible > solutions: > 1) input data as UTF-8 :)