In the early version of Navision it was only possible to handle string with a length up till 250 characters. This was often not enough and there was only a few ways to handle those strings. E.g. store the info in several fields, variables or a text file – that was imported to a blob field.
From Navision 4 it was suddenly possible to handle strings with a length up till 2147483647 characters – this is equivalent to 2 gb. In Navision 4 the data type BigText was introduced.
Read the rest of this entry »