Bugs item #2806351, was opened at 2009-06-15 02:20
Message generated for change (Settings changed) made by skinkie
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2806351&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: Clients CVS Head
>Status: Closed
Resolution: None
Priority: 5
Private: Yes
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: write error after copy into
Initial Comment:
The following informational error message is present at copy into time. It
might be extended...
sql>COPY 1203854 RECORDS INTO kvk FROM '/tmp/proper' USING DELIMITERS ',',
'\n', '""';
0 tuples
write error
I think it is related to a not valid input related to the use of " " within a
delimited part. Message is private due to the content of this query.
----------------------------------------------------------------------
>Comment By: Stefan de Konink (skinkie)
Date: 2009-06-15 03:01
Message:
This is a duplicate of bug 2177734; POSIX locale again.
The interesting thing is that after reading back the following does give
output:
/opt/monetdb-head/bin/mclient -lsql -Een_US.UTF-8 -H
/opt/monetdb-head/bin/mclient: warning: cannot convert local character set
en_US.UTF-8 to UTF-8
/opt/monetdb-head/bin/mclient: warning: cannot convert UTF-8 to local
character set en_US.UTF-8
sql>COPY 8 RECORDS INTO kvk FROM '/tmp/test' USING DELIMITERS ',', '\n',
'""';
!SQLException:sql:value 'Co�eratieve Rabobank \"Koudum\" B.A. I.L.'
while parsing 'Co�eratieve Rabobank \"Koudum\" B.A. I.L.", "Dubbelstraat
6", "8561BC", "Balk", "Hoofdvestiging"' from line 7 field 1 not inserted,
expecting type str
!SQLException:importTable:failed to import table
0 tuples
while:
-Eutf8 does not. [and just writes the previously mentioned error]
CREATE TABLE "sys"."kvk" (
"kvk" bigint,
"bedrijfnaam" varchar(255),
"adres" varchar(64),
"postcode" varchar(6),
"plaats" varchar(32),
"type" varchar(16)
);
So the solution was rather simple; though the following sequence of
commands still made me wonder if the -E actually works...
skin...@productie ~ $ iconv -o /tmp/test2 -f iso-8859-1 -t utf8 /tmp/test
skin...@productie ~ $ /opt/monetdb-head/bin/mclient -lsql
sql>skin...@productie ~ $ /opt/monetdb-head/bin/mclient -lsql -H
sql>COPY 8 RECORDS INTO kvk FROM '/tmp/test' USING DELIMITERS ',', '\n',
'""';
!SQLException:sql:value 'Co�peratieve Raboban Koudum B.A. I.L.' while
parsing 'Co�peratieve Raboban Koudum B.A. I.L.", "Dubbelstraat 6",
"8561BC", "Balk", "Hoofdvestiging"' from line 7 field 1 not inserted,
expecting type str
!SQLException:importTable:failed to import table
0 tuples
sql>COPY 8 RECORDS INTO kvk FROM '/tmp/test2' USING DELIMITERS ',', '\n',
'""';
Rows affected 8
sql>
skin...@productie /opt/monetdb-head/bin/mclient -lsql -Eiso-8859-1 -H
sql>COPY 8 RECORDS INTO kvk FROM '/tmp/test2' USING DELIMITERS ',', '\n',
'""';
Rows affected 8
sql>COPY 8 RECORDS INTO kvk FROM '/tmp/test' USING DELIMITERS ',', '\n',
'""';
0 tuples
write error
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2009-06-15 02:27
Message:
Ok this is again related to 'special characters'. I remember a question
from the mailinglist and my previous bug report on this matter...
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2806351&group_id=56967
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
