Bugs on COPY command
От
gwcom
Тема
Bugs on COPY command
Дата
Msg-id
000801c0b12d$75f689f0$8a00a8c0@bryan1
Список
Дерево обсуждения
Bugs on COPY command "gwcom" <bwu@gwcom.com>
Re: Bugs on COPY command Tatsuo Ishii <t-ishii@sra.co.jp>
Dear sir, I currently using postgresql V7.0.3. I created a database with UNICODE encoding to store chinese and japanese in= formation. 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 envir= onment. 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:=20 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 c= orresponding 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
В списке pgsql-bugs по дате отправления