Skip to Content.
Sympa Menu

freetds - Re: [freetds] error for insert into varbinary column: Implicit conversion from data type varchar to varbinary is not allowed

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] error for insert into varbinary column: Implicit conversion from data type varchar to varbinary is not allowed
  • Date: Wed, 24 Feb 2010 21:24:47 -0500

Hari Krishna Dara wrote:
> I am trying to insert data into a varbinary column from python via
> pyodbc and unixODBC and get the below error:
>
> Traceback (most recent call last):
>   File "test_pyodbc.py", line 36, in <module>
>     cur.execute(sql, (pyodbc.Binary(data),))
> pyodbc.DataError: ('22018', '[22018] [FreeTDS][SQL Server]Implicit
> conversion from data type varchar to varbinary is not allowed. Use the
> CONVERT function to run this query. (257) (SQLPrepare)')
>
> The error occurs no matter what the data contains and how long it is
> (happens with empty data also).

http://manuals.sybase.com:80/onlinebooks/group-cnarc/cng1110e/dblib/@ebt-link;pt=45151?target=%25N%15_12482_START_RESTART_N%25

Designed behavior. Binary != text.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page