Re: Trimed results from PostgreSQL-Database

Martin Neimeier wrote: > > Hello all, > > If i fetch a result-set from a PostgreSQL-table (using pg_Result, > pg_Fetch_Array, pg_Fetch_Object), all string-colums have trailing spaces > attached. > > Now the question: > > Is it posible to say the database, not to fill in trailing spaces ? If > yes how ? > (I dont want to use trim() on all columns !) > > cu > Martin > -- > -------------- > Martin Neimeier > Tel:+49(6262)912344 Fax:+49(6262)912347 > Hi, Sounds like you are using the 'char' type and not 'varchar'. varchar does not fill with spaces. Regards, Jason -- Jason Murray Developer jWeb New Media Design