PDA

View Full Version : sql script text replace truncating the value



jmather
07-19-2005, 02:37 PM
I have a sql script with two parameters that I've set to be replaced with global properties. One of the properties is ~60 characters. The replace works perfectly. The second property is a hex string of 1700+ characters. The text replace is truncating the value at 260 characters so what ends up in the database is invalid. I'm getting no errors during the install process. Anyone have an idea why this truncation is happening and how to fix it? Just for kicks I cut my hex string to 261 characters and it was getting still getting trucated. If it's 260 or less characters long, no truncation.

hidenori
07-20-2005, 11:47 PM
The replacement functionality supports up to 260 characters at this time. I submit the feature improvement work order #IOC-000034236 so that we would extend this functionality in a future release.

Thank you for reporting this.
Hidenori Yamanishi
Software Developer
Macrovision Corporation - Software Technologies Group