On Wed, Apr 16, 2008 at 09:10:14PM +0200, ewilde wrote:

hello again.

now i have another problem.

following your suggestion of using COPY INTO for the migration Do you use COPY INTO with a file ? If yes the file should contain 'utf-8' characters for monetdb to work.

Niels

of my database from MSSql to MonetDB5, i indeed succeeded in copying some tables, enjoying very good performances (for example, one table with ~8 millions of records in ~13 seconds).

the new problem i'm facing now is that using COPY INTO for data with hebrew letters ends up with error.

i tried to supply COPY INTO a UNICODE enoded file, but than i have not succeeded in defining the tuple and record seperators.

the MonetDB5 itself is capable of storing and retrieving hebrew letters. i can tell this because i have no problem inserting such data through JDBC (actually, right now i have a java process working hard and slowly on copying such a table). so the problem is probably somewhere in the mclient application. is there any workaround for that?

thanks,

ewilde.

------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl