Hi All,

I am the new member of this forum. Please help me out with the following query.

I have created a log table with 6 columns of different data type and size. out of these, two columns are with size 3000 each i.e. varchar(3000). I have checked with total size of table and its not even exceeding 8000. Everything was fine and the table was created successfully with out any error. Even while inserting data into that table its not throwing any error.

But to my surprise when I see the data in a table, the column size with varchar(3000) contains only 256 character data. that means the data of full size is not getting loaded. Its truncating.

Could any one please clarify why the size of 3000 is not holding 3000 char and why it holds only 256 char?

I am using sql server 2000 sp4 version

please let me know if any one require further information.

Hoping for a quick reply

Thanks

kawrat


kawrat

In Query Analyzer, from the menu go to Tools, Options, Results and increase the "Maximum characters per column" setting.

....You say: Even while inserting data into that table its not throwing any error. This cannot be correct. If you try to insert data into a column and your data is longer then the column will allow, SQL will throw a "String or Binary data will be truncated..." error.

Have you done a SELECT query on your table to look at the data?

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

Make certain that you are dealing with varchar and not nvarchar which has a limit of 4000 characters.

Rand

Yes you need to change the config of your Results Window from the query analyser.
In such cases you can also do a that would have cleared your doubt.

cheers.

_________________________
- Vijay G
Strive for Perfection

Thanks All. Appreciate for a quick reply.

Yes, configuration was a big issue. Thanks a lot this worked out.

But now it raises another query.

Instead of changing the configuration settings (from 256 – to 3000) is there any alternate option to read the data from the table via code?

Say we have a default option set to 256 maximum column char. Now if I want to read (SELECT) a data from a table I can read only 256 chars of column size 3000. Is there any possibility to read complete data (all 3000 chars) with out changing default settings?

Thanks in Advance


kawrat

Not from Query Analyzer.

Just an FYI, I change the default from 256 to 8000. Query results in the grid mode will automatically size correctly... and I hardly ever used the text mode although there are occasions.

--Jeff Moden

kawrat,

Did you try that with a PRINT statement on Query analyser? It should show you all that in TEXT mode.

Cheers

_________________________
- Vijay G
Strive for Perfection