[Microsoft][SQL Native Client]String data, right truncation

forum.connectivity (2000-2005) & forum.td.connectivity (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 115421
Joined: 24 Feb 2017, 12:00
Location: World wide

[Microsoft][SQL Native Client]String data, right truncation

Post by NewsgroupServer » 10 Apr 2010, 08:35

 Posted by:  F R Bhote 

If there is a table with a column having smaller width than the bind
variable in the select I get this error - how can I avoid this error?

eg:

CREATE TABLE X ( COL VARCHAR(3) );

SELECT * FROM X WHERE COL = :bind;

and the value of bind is 'ABCD' which is more than VARCHAR(3).

TIA

Return to “td.connectivity”

Who is online

Users browsing this forum: [Ccbot] and 0 guests