Skip to Content.
Sympa Menu

freetds - [freetds] [ freetds-Patches-1106465 ] quote column names for bcp

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "SourceForge.net" <noreply AT sourceforge.net>
  • To: noreply AT sourceforge.net
  • Cc:
  • Subject: [freetds] [ freetds-Patches-1106465 ] quote column names for bcp
  • Date: Thu, 20 Jan 2005 19:45:52 -0800

Patches item #1106465, was opened at 2005-01-20 22:45
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=407808&aid=1106465&group_id=33106

Category: db-lib
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Paul Rensing (prensing)
Assigned to: Nobody/Anonymous (nobody)
Summary: quote column names for bcp

Initial Comment:
With TDS version 7.0 and higher, bcp fetches the table
column names and then sends them back to the DB when
setting up the bcp transfer (in the "INSERT BULK"
statement). The problem occurs if you have spaces in
your column names; the column names are not quoted in
any way and the server gets confused.

Turns out (at least on MS SQLserver) that the way to
quote the column names is to use square brackets ("[",
"]"), not quotes. The patch modifies bcp.c to always
quote column names.

I have tested this against our MS SQLServer 2000. I
don't have any other system to test.

----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=407808&aid=1106465&group_id=33106




Archive powered by MHonArc 2.6.24.

Top of Page