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

Reply via email to