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

forum.connectivity (1998-2005) & forum.td.connectivity (2005-2010)
FRBhote
India
Posts: 1230
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

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

Post by FRBhote » 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 1 guest