Gregorio,

It has to do with the new varchar type and SQL statements that don't specify string length explicitly. Ensure that SET VARCHARMAPPING is OFF and change the SQL statement to specify string lengths and the problem should go away. Dunno why the ANSI setting would have anything to do with it.

>I have an application that was working fine in version 6,7,8 without error. After we migrate to 9.0 in our testing process look ok. Now in a real world a client that have one of the biggest demand have a complaint because a regular process that normally take like 3 minute to complete is taking hours. Any person have any idea where I have to start looking. Was working fine in previous version so I dont want to modifie anything before I check that is something that I need to do with the setup of 9.0 in order to work fine.