Thread

1. Bugs on COPY command

   gwcom <bwu@gwcom.com> — 2001-03-20T11:03:46Z

   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
   

2. Re: Bugs on COPY command

   Tatsuo Ishii <t-ishii@sra.co.jp> — 2001-03-21T05:30:21Z

   > 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