SqlServer to PostgreSql

Поиск
Список
Период
Сортировка
Искать

SqlServer to PostgreSql

От:
Luis Felipe Acevedo Fernandez <luis.felipe@unibase.com.mx>
Дата:
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

От:
Kevin Brannen <kevinb@nurseamerica.net>
Дата:
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

От:
Ludwig Lim <lud_nowhere_man@yahoo.com>
Дата:

--- 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   " 
> 

  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
FAQ