SQL Server Performance Forum – Threads Archive

varchar limit

Hi there,
I have a table with a varchar colum in the length of 1024. Inside it, I have a text in the size of 500 characters. My problem is that when I fetch the data in my "C" code, the text gets cut out to 256 characters. I defined my "C" variable as char [4000].
I use SQL server 2000. Please help
Thanks

Check out set textsize. (I think that’s what you are looking for)

Do you know how to set it up in a ‘C’ code ? Thanks

post your c code on this matter,
i dod not recall ever seeing code that limits the text size to 256
do you know how to run profiler?
do so with the default template, filter for the hostname of your app,
when it opens a connections, look for an entry like: SQL:BatchCompletedSET TEXTSIZE 64512 the relevent c code should look something like: SQLCHAR SalesPerson[11];
SQLINTEGER SalesPersonLenOrInd, CustIDInd; SQLBindCol(hstmt, 1, SQL_C_CHAR, SalesPerson, sizeof(SalesPerson), &SalesPersonLenOrInd);

There is my code, what SQL sentence should I include ? I don’t know what ‘profile’ is. Thanks, Eli EXEC SQL BEGIN DECLARE SECTION; charpcHolesPos[4000] = ""; EXEC SQL END DECLARE SECTION; EXEC SQL SET OPTION LOGINTIME 10; EXEC SQL SET OPTION QUERYTIME 100; EXEC SQL SET CURSORTYPE CUR_BROWSE; EXEC SQL DECLARESEL_M_TEMP_CUR CURSOR FOR SELECTholes_pos FROMM_TEMP ORDER by template_id; EXEC SQL OPEN SEL_M_TEMP_CUR; for(i = 0 ; SQLCODE == 0 ; i++) { EXEC SQL FETCH SEL_M_TEMP_CUR INTO<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />cHolesPos; if(SQLCODE == 0) { strcpy(psMTLocalArrayPtr.cHolesPos,pcHolesPos); } else if(SQLCODE != 100) { // Error … } } } EXEC SQL CLOSE SEL_M_TEMP_CUR;

]]>