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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org