you'd use VARCHAR, CHAR is fixed width. If you want to force it, use a TypeDecorator that calls strip() on the returned values.
On Apr 15, 2010, at 5:28 AM, Eric Lemoine wrote: > Hi > > I use PostgreSQL and I have this column if one of my tables: "ens" > character(60). I use "autoload" in my model for that table. SQLAlchemy > 0.5.8 always gives me strings with 60 characters (with trailing > spaces) when doing queries. I wouldn't expect that. Is there a way to > change that behavior? > > Thanks a lot, > > -- > Eric Lemoine > > Camptocamp France SAS > Savoie Technolac, BP 352 > 73377 Le Bourget du Lac, Cedex > > Tel : 00 33 4 79 44 44 96 > Mail : [email protected] > http://www.camptocamp.com > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
