Postgres Pro
Downloads
Home   >   mailing lists

Thread: SqlServer to PostgreSql

SqlServer to PostgreSql

From
Luis Felipe Acevedo Fernandez
Date:
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

Re: SqlServer to PostgreSql

From
Kevin Brannen
Date:
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

Re: SqlServer to PostgreSql

From
Ludwig Lim
Date:
--- 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