varchar(MAX) settings

[NickyJay]

Hiya all, dont know if this is the right forum for this question, but hope someone can help!!

I have a page that connects to my SQL Server (2005) db. One field in a table is currently set to varchar(MAX) as it is intended to hold a lot of text.

When i try to output the contents of this field on my CFML end output page, all i get is various odd characters rather than the acctual text that is in the db.

I have searched this on the net and found it is not unique to CFML but happens in ASP also, which led me to thinking it could the be field properties of the db and not the method of connecting i am using.

Additional to this, i have changed the field to be varchar(8000) and the text output's correctly!!

Am i able to change any settings on the varchar(max) field or is this just how it works??

Any advice on this is appreciated!!

Thanks

Nicola

 

[drtree]

Hi Nicola,

I did some quick research myself and it looks like it may be that ASP (or CFML, I'm assuming) does not support the new data type - check this out -

http://forums.iis.net/t/1051953.aspx

Hope that helps,

Dr Tree