I guess varchar(max) is the new way to go instead of text. But for some odd reason when I echo out my results from my simple select statement it only displays maybe a quarter of whats actually stored in sql.
If I use ms sql server management studio and do the select it shows everything correctly, if I do it in my php code it doesnt.
Here is my sql string.
SELECT notes FROM tblContacts
fairly straight forward :)
Is there something special I need to be doing in php to make it actually get the full value of whats stored in the varchar(max)?
I tried CAST(notes as TEXT) as notes but that did the same thing only displayed maybe a quarter of it, almost like its sticking to that 255 character limit.
Thanks for any help!
-- Edit --
I should also add that it is not throwing any errors at me.