Bugs on COPY command

Started by gwcomabout 25 years ago2 messagesbugs
Jump to latest
#1gwcom
bwu@gwcom.com

Dear sir,

I currently using postgresql V7.0.3.
I created a database with UNICODE encoding to store chinese and japanese information.
I have some chinese information created with MS access(excel) and export it to text file
with delimiter semi-colon ";" .
When I imiport the text file into the table with COPY command in psql environment.
e.g. COPY tablename from '/import/file/path' using delimiters ';'
The data import successfully but some strange results are found.
Some record contains the field value with delimiters.
For example, we have the following line in the import file:
abc;def;hij;kil;mnx

The result may be
field 1:abc
field 2:def
field 3:hij;kil
field 4;mnx
field 6:

It seems that the copy command can't paser all data successfully into the corresponding fields.
I don't know why and I must use ';' as the delimiter since I have no choice.
All the information abc,def,hij,mnx are BIG5 characters (I only try BIG5)
Do anyone have report this strange behaviour?

Regards,
Bryan Wu
lfwu@yahoo.com

#2Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: gwcom (#1)
Re: Bugs on COPY command

I currently using postgresql V7.0.3.
I created a database with UNICODE encoding to store chinese and japanese information.
I have some chinese information created with MS access(excel) and export it to text file
with delimiter semi-colon ";" .
When I imiport the text file into the table with COPY command in psql environment.
e.g. COPY tablename from '/import/file/path' using delimiters ';'
The data import successfully but some strange results are found.
Some record contains the field value with delimiters.
For example, we have the following line in the import file:
abc;def;hij;kil;mnx

The result may be
field 1:abc
field 2:def
field 3:hij;kil
field 4;mnx
field 6:

It seems that the copy command can't paser all data successfully into the corresponding fields.
I don't know why and I must use ';' as the delimiter since I have no choice.
All the information abc,def,hij,mnx are BIG5 characters (I only try BIG5)
Do anyone have report this strange behaviour?

Copying BIG5 data to/from UNICODE database? This doesn't work at all
in 7.0.3. Try 7.1beta...
--
Tatsuo Ishii