2. ASPRunnerPro General questions
  3. Field Length Max?
This topic is locked

Field Length Max?

 		5/15/2004 3:27:40 PM
ASPRunnerPro General questions
B
 berga@alpenacc.net author

Yet another questions....but I searched the forum first, didn't find.
In my database, I have a field in excel that can be rather large sometime in excess of 1,200 characters. In the asp web page, it is only displaying 255.
255 is a magic number, but can it display more than that. If not, suggestions on how do get this many characters to display? Thanks
Allan
PS. It's find in excel, all 1,200 characters are there
B
 		berga@alpenacc.net author 5/15/2004

I've kinda of answered the question by changed in the edit field type to "text", but this only works on my local machine....everything is fine, all 1,200 characters display on the local machine, but when uploaded to my website, it's the same thing, only 255. ??
B
 		berga@alpenacc.net author 5/15/2004

I'm still baffled by this....I've played around with the field formatting options, but to no avail.
When viewed on the http://localhost/*.asp everything is great, all the characters appear....
When uploaded (same files) to the web, it reverts to the same 255 characters...not the entire thing.
I actually took snapshots of this if you want to see it. Let me know.
Thanks.

Allan
B
 		berga@alpenacc.net author 5/18/2004

I still cannot figure this out!! HELP!
Sergey Kornilov 5/19/2004

From my own experience Excel is very unreliable database when it comes to working with large text fields (more then 255 characters). In most cases Excel just truncates data.
Converting your database to MS Access will solve this issue.
B
 		berga@alpenacc.net author 5/19/2004

Thanks...Access worked.