Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
if you define the length as 80,
then the following characters will be space,
if you put spaces into the text field.
means: in a varchar you define exactly the
needed length for a field.
in your case: 'hallo' is five bytes,
therefore it makes sense to give a length of 5.
if you read this field now, you will only get
the length in a proper way, the rest of the field,
(not stored in db), will be set to hex'00'.
note: you should always determine the length field first,
because, if you have length = zero, the field is empty,
and empty means really empty, all is hex'00'.