[Lazarus] Never change...

[Hans-Peter Diettrich]

On Fri, May 15, 2009 at 12:12 PM, Graeme Geldenhuys
<graemeg.lists at gmail.com> wrote:
> database and got some strange results in the Lazarus DB components.

The following could explain the strange results (extra spaces).

  http://www.janus-software.com/fbmanual/manual.php?book=PSQL&topic=33

"The VARCHAR(n) datatype contains text of varying length, up to a
maximum of n characters. The maximum size is 32,767 bytes, which can
be 10,992 to 32,767 characters, depending on the character size (1..3
bytes). You must supply n; there is no default to 1.

Firebird converts from variable-length character data to fixed-length
character data by adding spaces to the value in the varying column
until the column reaches its maximum length n. In the reverse
conversion, trailing blanks are removed from the text."

Firebird pads the characters with spaces which Sqldb or LCL doesn't
remove. Or that's how it seems...


Regards,
  - Graeme -


_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://opensoft.homeip.net/fpgui/