>>The very idea that a text file can be trusted to carry data, delimited by characters that may be expected to exist inside the data, is the initial bug.
>
>What a nonsense! The COPY TO CSV should have added the second double quote. THERE is the bug.
Second? There are four already :). Or you mean it should have doubled, the contained quotation marks, perhaps? To create something BASIC-styled like
txt
"is weer ""ziek"""
That would have been a beginning of that contract, provided that the append command would know to convert double quotation marks into single, and treat the odd quotation marks as delimiters... unless in position 1 where the initial one is taken as the delimiter and then it should expect text after that. I.e. in
"""this"" is not ""that"""
There from the first triplet the first q.m. is the delimiter, and the other two are to be interpreted; from the last triplet the first two are to be interpreted and the last one is a delimiter. Which, for instance, LibreOffice's Calc does just fine. But it was written ages after Fox.
>> Everything else is a blind implementation of that idea. Anything trying to implement that without a firm contract between the sender and recipient will be buggy.
>>
>>In this case, the bug is in the "copy to effe type csv" command - it produces this:
>>i.e. it blindly wraps quotation marks around a string containing quotation marks. It doesn't even have a contract with itself. That, yes, that is a bug.
>
>Again, what a nonsense! The APPEND FROM CSV should have converted the double double quotes to a single double quote. THERE is the accompanying bug.
I tried to append the above example ("""this"" is not ""that""") and it appends zero records. Which is an even larger bug.
But still, there's no firm rule as to how to incorporate quotation marks inside a string which contains quotation marks. In many systems they need to be doubled, in many they need to be escaped (and then there are several methods on how to escape them). The true bug, to me, is not that it doesn't properly import from an ill-defined standard, but that it doesn't properly import its own export.