SitePoint Sponsor |
|
User Tag List
Results 1 to 10 of 10
Thread: nvarchar(max) npt displaying
-
Jun 9, 2009, 08:48 #1
nvarchar(max) npt displaying
Why won't my nvarchar(max) field from sql display in coldfusion? I get no error, just a blank screen!
cheers
monkeymonkey - the rest is history
-
Jun 9, 2009, 09:32 #2
- Join Date
- Apr 2009
- Location
- Wallingford, CT
- Posts
- 92
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
-
Jun 9, 2009, 09:47 #3
how would i do that?
monkey - the rest is history
-
Jun 9, 2009, 11:04 #4
- Join Date
- Apr 2009
- Location
- Wallingford, CT
- Posts
- 92
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
-
Jun 10, 2009, 01:41 #5
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).monkey - the rest is history
-
Jun 10, 2009, 09:34 #6
- Join Date
- Apr 2009
- Location
- Wallingford, CT
- Posts
- 92
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
-
Jun 15, 2009, 06:46 #7
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
-
Jun 15, 2009, 06:50 #8
-
Jun 15, 2009, 06:52 #9
It should enable the Unicode fromt he database to come across correctly.
-
Jun 15, 2009, 06:54 #10
Bookmarks