varchar more than 255 vharacters allowed

[mouniryoussef]

Hi all,

using sql server 2000 sp3

i have filed (description varchar(370)), i can update this field (with 370 characters ) but when i select it i get always 255 characters it means the data is truncated up to 255 chars.
do you have any idea about that or some work arround. ?

thanks a lot
Mounir Youssef

 

[Catadmin]

Go to Tools -> Options -> Results in QA and change the "Maximum Characters Per Column" to whatever value you want it to be so you can see your whole field.

Then you'll just need to drag out the right column edge in the results grid when you do your select statement and you should be able to see everything.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[sunila7]

How are you inserting data? If you are using ADO.NET to insert/update make sure that you are specifying the Size property of the Parameter object. If you don't specify the Size Property the default Size of 255.



Sunil

 

[mouniryoussef]

thanks for your fast replies,

OKi , in my SQl query analyser i can see that there is more that 255 characters thanks.

in my front-end application; i m using the standard update statement to update the decription filed and the update is succeful. but i try to select this field it s always truncated to 255 even the filed is varchar (370).

thanks

 

[mouniryoussef]

hi all,

i found that they are using the MSS sql sever 6.5 driver to connect to the database. that cannot support data bigger than 255 characters. i tried ODBC or OLE DB and it works.
another probleme appers that via oDBC drivers cannot see the stored procedures (spo.mystoredprocedure)...

thanks for your support