Hi,
for example, it cannot import the column value
19" rack
because it stays in quotation mode until it finds a further ", which is
incorrect. Quotation mode may only get activated when " appears at the
beginning of a column value.
Once the line has been broken into column values, the import command properly
handles that rule when dequoting each column value before inserting the row
into the table.
Besides this bug, it would be nice if the quotation character could be
specified like the separator, so that de-/quoting can even be turned off it the
file hasn't been created appropriately. E. g. sqlserver bulk import does not
support quoting, hence the files may not be created with quoting turned on.
Mit freundlichen Grüßen / Best regards
Reinhard Nißl
Softwareentwicklung
F.EE GmbH Informatik + Systeme
Industriestraße 6e, 92431 Neunburg v. W.
Phone +49 9672 506-198
Fax +49 9672 506-10198
E-Mail: reinhard.ni...@fee.de
Internet: www.fee.de<http://www.fee.de/> -
www.fee-systemhaus.de<http://www.fee-systemhaus.de/> -
www.factwork.de<http://www.factwork.de/>
Geschäftsführung: J. u. G. Fleischmann
Geschäftssitz: Neunburg v. W., Amtsgericht Amberg HRB 1290
Diese E-Mail ist allein für den bezeichneten Adressaten bestimmt. Sie kann
rechtlich vertrauliche Informationen enthalten. Wenn Sie diese E-Mail
irrtümlich erhalten haben, informieren Sie bitte unverzüglich den Absender per
E-Mail und löschen Sie diese E-Mail von Ihrem Computer, ohne Kopien
anzufertigen. Vielen Dank.
This email is for the exclusive use of the addressee. It may contain legally
privileged information. If you have received this message in error, please
notify the sender by email immediately and delete the message from your
computer without making any copies. Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
