You are hitting the size limitation when you jump from 40 to 41/42 characters and then it is doubling. Try changing your nvarchar field to 160.
Ryan
At 04:13 PM 12/18/2002 -0600, you wrote:
I'm using CF Studio 5 on Win2000, and our db is MS SQL 7 on NT 4. One of my apps started acting up
when a user tried to enter a long client name in a form. An error about right truncation. Studio's
db tab told me that field was 80 characters wide (nvarchar). But it kept choking on a 42-character
name. I went back to our server room and checked field widths from the Enterprise Manager. Each
field there shows a value half of what Studio tells me. So my 80-character field will only take 40.
Easy enough to change but what's up with the misrepresentation? It does not do this with other data
types.
Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
Email: [EMAIL PROTECTED]
______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
