Knowledgebase

Home » Item #978

Product description truncates even though I have set the truncation to a high value in the config settings

Item: #978
Date: 4 Jul 2007
Applies to
v6

Question

I have set the truncateproductdescription to more than 255, but all this does is remove the ... after the product description on the prodtype.asp page. I still cannot get descriptions longer than 255 characters. Why is this?

Answer

This only affects MS Access based sites, and is due to a limitation within the joins in the MS Access drivers ("JET"). There is a good technical explanation here:

Truncation of Memo fields

Since this is an inherent limitation of the drivers, there is presently no workaround. MS SQL does not have the same limitation.

Can't find the answer you need? Click here to open a support ticket.

« Back