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>
Drag n’ drop—Get easy photo sharing with Windows Live™ Photos. http://www.microsoft.com/windows/windowslive/photos.aspx