In addition to the SmallDateTime bug outlined in a previous post, I also encountered this troublesome bug involving truncated SQL data because of a MSSQL nuance on lengthy VARCHAR fields. The Lost Field of Text There existed several string/text fields in the legacy MSSQL database defined with 1000-8000 character capacity. However initially I was only getting the first 255 characters.
Blog posts tagged with: MSSQL
Pixo is currently developing a web-based publication workflow application for American Library Association’s Choice Magazine and Choice Reviews Online utilizing the PHP framework Symfony to build a web based publication workflow application. A major component includes migrating 30+ years of legacy data out of a MSSQL database into a redesigned SQL schema in Symfony. Early in the project, I encountered this particularly nasty problem regarding smallDateTime fields as I was setting up the MSSQL side of the migration using the default MSSQL PHP driver.