Hi Sjoerd,
   Can you send me your test file and table schema please.
 

> Date: Tue, 6 Jan 2009 16:11:58 +0100
> From: sjoerd@acm.org
> To: monetdb-users@lists.sourceforge.net
> Subject: Re: [MonetDB-users] Copy from file which contains Chinese characters failed.
>
> The mclient -E option only affects data that flows through mclient, that
> is, mclient's standard input and standard output. When you use a copy
> into from file, the file is read directly by the server and not by
> mclient, and the server wants UTF-8 encoded data. This means that the
> data file must be UTF-8 encoded. Nothing else will do.
>
> My Windows system doesn't speak Chinese, so I can't really test it
> there, but on Linux it works correctly when I make sure the data is
> indeed correctly encoded.
>
> If you have the data in some other format, you should be able to do
> something like
> mclient -Eencoding file
> where file contains (in the specified encoding):
> copy 2 records into t1 from stdin using delimiters ',','\r\n';
> 1,测试1
> 2,测试2
>
> But this requires the copy command to be in the file as well.
>
> 小波 顾 wrote:
> > Copy from file which contains Chinese characters failed.
> > My test table is
> > create table t1(a int not null primary key, b varchar(1024));
> > My test file d:\data.txt contains two lines
> > 1,测试1
> > 2,测试2
> > I have tried to save the data file using ANSI and UTF8 encoding using
> > Notepad on windows,
> > and tried to start mclient with -Ecp437, -Ecp936 and -Eutf-8 option,
> > neither combination of the
> > file encoding and mclient encoding can load the file correctlly.
> > When both using utf-8 the following error messages appears:
> > sql>copy into t1 from 'd:\\data.txt' using delimiters ',', '\r\n';
> > !SQLException:importTable:failed to import table
> > !ERROR: value '�' while parsing '�,顾小�
> > !ERROR: 2,覃� from line 0 field 0 not inserted, expecting type int
> > !ERROR: TABLETload_bulk: read error (after loading 0 records)
> > 0 tuples
> > When using other combinations, the following messages appears:
> > sql>copy into t1 from 'd:\\data.txt' using delimiters ',', '\r\n';
> > 0 tuples
> > write error
> > sql>
> > The following steps works, but the exported data.txt isn't readable by
> > human.
> > mclient XXXXX -Ecp437
> > delete from t1;
> > insert into t1 values(1,'²âÊÔ1');
> > insert into t1 values(2,'²âÊÔ2');
> > copy select * from t1 into 'd:\\data.txt' using delimiters ',' ,'\r\n';
> > delete from t1;
> > copy into t1 from 'd:\\data.txt' using delimiters ',' ,'\r\n';
> >
> >
> >
> > ------------------------------------------------------------------------
> > Get news, entertainment and everything you care about at Live.com. Check
> > it out! <http://www.live.com/getstarted.aspx >
> >
> >
> > ------------------------------------------------------------------------
> >
> > ------------------------------------------------------------------------------
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > MonetDB-users mailing list
> > MonetDB-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
>
> --
> Sjoerd Mullender
>

---

Get easy photo sharing with Windows Live™ Photos. Drag n’ drop