Hi,
In Oracle, when ProIV populates a varchar2 col, spaces to the right of the value are trimmed. In sql server this doesn't seem to be the case for varchar cols. I was wondering if there is a config parameter in ProIV or sql server so that ProIV's behaviour on sql server matches Oracle's. Thanks.
Lastenia.
Click the link below to see the new game I'm developing!
ms sql server and spaces in columns
Started by
lastenia_rojas
, Jul 06 2006 09:40 PM
7 replies to this topic
#2
Wim Soutendijk
-
- Members
-
- 216 posts
ProIV Guru
- Gender:Male
- Location:Netherlands
Posted 07 July 2006 - 06:34 AM
It depends on how you create your tables in SQL Server
If you use a SET ANSI_PADDING OFF
before the CREATE TABLE command, the extra spaces send by pro-iv will be trimmed by the database
If you use a SET ANSI_PADDING OFF
before the CREATE TABLE command, the extra spaces send by pro-iv will be trimmed by the database
Edited by Wim Soutendijk, 07 July 2006 - 06:35 AM.
#5
Mike Schoen
-
- Members
-
- 198 posts
Expert
- Gender:Male
- Location:Guelph, Canada
Posted 24 July 2006 - 01:48 PM
Is anyone running with the padding turned off?
We have been testing with sql padding off, and have not experienced any problems.
We had originally turned it off, because in mssql query analyzer, we found we had to include the trailing spaces in selects to find data.
Eg: select * from CUST where LASTNAME = 'CASH '
instead of select * from CUST where LASTNAME = 'CASH'.
We have been testing with sql padding off, and have not experienced any problems.
We had originally turned it off, because in mssql query analyzer, we found we had to include the trailing spaces in selects to find data.
Eg: select * from CUST where LASTNAME = 'CASH '
instead of select * from CUST where LASTNAME = 'CASH'.
#7
Lewis Mccabe
-
- Members
-
- 455 posts
ProIV Guru
- Gender:Male
- Location:Sarasota, Florida
Posted 25 July 2006 - 02:50 PM
I checked on expert exchange for issues related to ANSI_PADDING. The issues all appear to be related to importing/ exporting from/to various database versions. There was no mention of not using it because there were problems with it.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
Click the link below to see the new game I'm developing!
