Re: SqlServer to PostgreSql

Luis Felipe Acevedo Fernandez wrote:
> Hi!
> I triyed to migrate a database from SqlServer to PostgreSql, but I have a
> problem with char or varchar data types cos If I try to insert or select some
> information from a table the program retrieve blank spaces, my program was
> develop in PowerBuilder 7
>
> Example If there is a table with a column char(5) and I insert the word "Hi"
> with 2 character when the program try to retrieve the information
> it gets "Hi   "
>
> thats my problem i hope some one  can help

That is proper behavior for the "char" datatype.  Change your column to
"varchar(5)" and you should get what you want--no padding with spaces.

HTH,
Kevin