7 replies to this topic

[lastenia_rojas]

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.

[Wim Soutendijk]

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

Edited by Wim Soutendijk, 07 July 2006 - 06:35 AM.

[lastenia_rojas]

Thanks. Will try that.

[Lewis Mccabe]

In their SQL Server 2000 docs Microsoft warns that ANSI_PADDING should always be set to on. I don't quite know why but they even put a red exclamation on it.

[Mike Schoen]

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'.

[jcduym]

Hi,

Our site has been running for years on a SQL-sever database with ANSI-padding off. Not noticed any problems


Jan

[Lewis Mccabe]

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.

[Mike Schoen]

Thats exactly what I wanted to hear, thanks for your replies.

Mike