xp-framework/rfc — Issue #182: Quoting in CSVGenerator
Author: thekid
Created: 2011-10-17 16:03:33+00:00
State: closed
Labels: framework, obsoleted

Scope of Change
====
the text.CSVGenerator will be extended by a flag that forces fields
to be quoted.

Rationale
====
When Sybase reads data from a CSV file it trys to detect the escape
character by looking at the first character of a datafield, as you can
see in the attached document.
This leads to too wrong data interpretation if a field starts with a
single-quote while the escape character was set to doube quotes.

Functionality
====
Setting the force_quotation flag to true would enclose all field
into quotations. So the first character of a field is allways the
actual escape character.

Security considerations
====
none

Speed impact
====
Fully quotation might be a bit slower.

Dependencies
====
none

Related documents
====
http://manuals.sybase.com/onlinebooks/group-pbarc/conn5/sqlug/@Generic__BookTextView/46795;pt=46795;