Обсуждение: SqlServer to PostgreSql

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

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

--- Luis Felipe Acevedo Fernandez
<luis.felipe@unibase.com.mx> 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   "
>

  I also encountered the same problem in Oracle when
porting char(n) datatypes.  Since char(n) datatypes
pads the string with spaces until it has n number of
characters.  What you can do is you can use either
ltrim,rtrim in selecting the data from SQL Server, or
use the trim() function in the PowerBuilder before
inserting it to a postgres database.

ludwig



__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com