[MonetDB-users] COPY INTO of data containing hebrew letters
hello again.
now i have another problem. following your suggestion of using COPY INTO for the migration 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.
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
participants (2)
-
ewilde
-
Niels Nes