nvarchar(max) npt displaying

[boxhead]

Why won't my nvarchar(max) field from sql display in coldfusion? I get no error, just a blank screen!

cheers

monkey

[xheartonfire43x]

Why won't my nvarchar(max) field from sql display in coldfusion? I get no error, just a blank screen!

cheers

monkey

Did you try dumping the query to see if you get anything there?

[boxhead]

how would i do that?

[xheartonfire43x]

how would i do that?

Use:

<cfdump var="#yourqueryname#">

It is a very useful tag for debugging.

[boxhead]

very useful - cheers.

The recordset seems to just contain [empty string] in the field containing the nvarcahr(max) data - there is definatley somthing in there! If i change the field type in SQL Server to 'text' it works fine (however, this causes lots of other issues, hence using nvarchar in the first place).

[xheartonfire43x]

very useful - cheers.

The recordset seems to just contain [empty string] in the field containing the nvarcahr(max) data - there is definatley somthing in there! If i change the field type in SQL Server to 'text' it works fine (however, this causes lots of other issues, hence using nvarchar in the first place).

Hmm I don't really use nvarchar(max) so I am not sure. It has be an issue with your SQL then. Are you able to post it on here, for us to see?

[Paul_K]

In the CFAdmin select the data source and presum9ing your using MS SQL server select this option:

String Format -- Enable High ASCII characters and Unicode for data sources configured for non-Latin characters

[boxhead]

In the CFAdmin select the data source and presum9ing your using MS SQL server select this option:

String Format -- Enable High ASCII characters and Unicode for data sources configured for non-Latin characters

What will this do?

[Paul_K]

It should enable the Unicode fromt he database to come across correctly.

[boxhead]

It should enable the Unicode fromt he database to come across correctly.

Sorry Paul - i've got 2 threads going at the mo and thought you'd answered the other, which made no sence

That makes sence, I'll give it a go

cheers