From: | Kevin Brannen <kevinb(at)nurseamerica(dot)net> |
---|---|
To: | luis(dot)felipe(at)unibase(dot)com(dot)mx |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: SqlServer to PostgreSql |
Date: | 2002-07-10 15:58:31 |
Message-ID: | 3D2C59A7.5090304@nurseamerica.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2002-07-10 16:18:32 | View chached inside function |
Previous Message | Hal Lynch | 2002-07-10 15:49:42 | Re: Authentication in batch processing |