> 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:
> 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...
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2001-03-21 05:34:56|
|Subject: Re: libpqeasy cursor error after multiple calls|
|Previous:||From: pgsql-bugs||Date: 2001-03-21 04:28:23|
|Subject: Doc bug: libpq PQconnectPoll()|