Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-14 : 08:13:23
|
| Frank writes "Hi,I have a Microsoft internet data connector (hosted by Microsoft IIS) which is connecting to a MS SQL Server 2000 database. The problem I am having is that I have a few fields within the database that can contain long text strings (up to 8,000 characters). I have these fields defined in the SQL Server database as nvarchar(length). The IIS idc's are all working and are all returning results, but the long text fields are only returning the first 39 characters of the string. I was hoping you might have a suggestion.I see on your own site you have that resolved, so maybe you can tell me what I need to do differently.Thanks so much for anything you can suggest!" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-12-14 : 08:35:05
|
nvarchar can have only 4000 chars. varchar can have 8000.maybe you're not passing the paramters correctly??Go with the flow & have fun! Else fight the flow  |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-12-14 : 12:36:40
|
| Frank, we'd need to see more specifics about how you are querying the database such as the specific SELECT statement or stored procedure call.By the way, am I remembering my acronyms correctly? When you say a "Microsoft internet data connector" are we talking about .idc files (often used in conjunction with .htx)? Wow! I haven't seen those in what seems like an eternity. I hope you're planning to migrate to (at least) ASP pretty soon. You'd be amazed at how much more you can do.-----------------------------------------Professional IT Solutions from Infoneering |
|
|
|
|
|
|
idc query against SQL Server only returns first 39 chars