Rt Ibmer wrote: > I was going crazy trying to figure out why my COPY RECORDS command wasn't > working. Turns out it is caused from funny (encoded?) characters in the > string for one of the fields. > > For instance one of the fields contained this "?a?as?e??, 18 ?a??? 2001 > 10:24:00 pµ" > > How did the data get this way? Well I exported it from SQL Server and I guess > that db is set up to store encoded characters. When I did the export I told > SQL Server to make the file ASCII since I figured that is what COPY RECORDS > expects. So apparently SQL Server is writing the characters this way into > the string. Then MonetDB (latest version) cannot handle this. > The details of SQL Server side can not be answered. MonetDB expects the control characters in the records to be encoded in the C-style, i.e \ddd. Using e.g. a null byte will terminate a line and will cause the parsing of the fields to go astray. > So what happens is that the COPY x RECORDS command just returns immediately > after I try this with this data in it. After that all my SQL statements in > mclient return immediately. So I can say "select count(*) from foo;" and it > just comes immediately back with the sql> prompt. So something with these > funny characters sends mclient into a funk. I have to exit and restart it to > get it going again. > > Any advice on how to handle this? Thank you. > > > > > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Monetdb-developers mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-developers >
------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
