Text11 stored in Text10

eYe
eYe Member Posts: 169
edited 2009-01-15 in NAV/Navision Classic Client
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?
Kind Regards,
Ewald Venter

Comments

  • garak
    garak Member Posts: 3,263
    oh, i know that there was a bug in the 2.00 database.
    But still in the 4.00?

    it's a customized field?
    Do you make it right, it works too!
  • eYe
    eYe Member Posts: 169
    Yes it is a custom field.
    Kind Regards,
    Ewald Venter
  • garak
    garak Member Posts: 3,263
    did you stream in there some datas? or did you change the lenght?
    Do you make it right, it works too!
  • DaveT
    DaveT Member Posts: 1,039
    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 :wink:
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • eYe
    eYe Member Posts: 169
    That explains how it is stored there, not entirely how it got in there.
    Kind Regards,
    Ewald Venter
  • DaveT
    DaveT Member Posts: 1,039
    Hi,

    Normally through a dataport or other type of import.
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • eYe
    eYe Member Posts: 169
    Wouldn't NAV have given a error. Like a Text to Text overflow?
    Kind Regards,
    Ewald Venter

Categories