Text11 stored in Text10

eYe

Hi

I just found a value of length 11 in a Text10 field. FieldClass = normal.
(Native NAV4SP1)

How is it possible for something like this to happen?

garak

oh, i know that there was a bug in the 2.00 database.
But still in the 4.00?

it's a customized field?

eYe

Yes it is a custom field.

garak

did you stream in there some datas? or did you change the lenght?

DaveT

Hi Guys,

The answer is buried in the application developer guide

Note

In C/SIDE Database Server, data is stored with a four byte alignment because of
performance considerations. The sizes of text, code and binary fields (that can have
variable lengths) are rounded up to the nearest value that is a multiple of four. This
means that, for example, a text string of 10 characters will occupy 12 bytes.

So it will allow you to store the 11 characters even though it should only be 10

eYe

That explains how it is stored there, not entirely how it got in there.

DaveT

Hi,

Normally through a dataport or other type of import.

eYe

Wouldn't NAV have given a error. Like a Text to Text overflow?