I think that you must use varchar instead.

Dufloth.

----- Original Message -----
From: "meiers_much" <sven@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, July 22, 2002 9:51 AM
Subject: [ib-support] Sybase to FireBird migration


> Hi,
>
> we're currently migrating our java project from sybase to firebird.
> We now have trouble with char(n) columns - Sybase returned values
> with trailing whitespace stripped off while Firebird returns the
> values padded to n chars.
>
> e.g. let name be a column of typ char(10):
>
> select name from person
> (Sybase) -> "Duke"
> (Firebird)-> "Duke______" (_ meaning whitespace)
>
> Can somebody give me a suggestion how to handle this?
>
> Should I change all columns from char to varchar or is there a
> general switch that I could use (preferred)?
>
> Thanks
>
> Sven
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>


---
Este e-mail foi enviado livre de vírus.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.377 / Virus Database: 211 - Release Date: 15/07/2002