Ah, Excellent. Thanks guys.
-----Original Message-----
From: Nic Wise [mailto:[EMAIL PROTECTED]]
Sent: Monday, 18 December 2000 14:38
To: Multiple recipients of list delphi
Subject: Re: [DUG]: Interbase spaces
> I'm just starting a new project and have decided to use Interbase 6 with
> IBX.
> I've noticed that when saving data to a table, spaces are added to pad the
> field out to it's exact length. eg: if I have a field Char(6) and save the
> value 'ABC', then what looks like is actually saved is 'ABC '. Why is
this
> and is there a way to stop it saving the spaces?
its standard for CHAR fields - use VARCHAR instead - it doesn't append
spaces, and it uses less space if you put less info in the first.
> It's a pain when loading the data, as when I populate my form, it has the
> extra spaces in the edit boxes etc.
:)
N
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
