Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datatypes

Status
Not open for further replies.
DarkMan

DarkMan

Programmer
Apr 13, 1998
222
US
When I submit a question of length over 255, I get an error saying that implicit conversion from text to varchar is not allowed. The column is text datatype, like the reply column. I am not having this problem with the replies. What's going on?
 
Sort by date Sort by votes
Why not forward this as a feedback directly to their Webmaster/Administrator?
 
Upvote 0 Downvote
Actually, I found the problem....It was in this web page. It turns out that when I tried to access the record, it was trying to return the question as a varchar type instead of the text type it was assigned to. The error message I got did not indicate which query (of several) was giving me the problem and the select query mentioned was the last place I expected the error to be in. (Besides, being the administrator, I had no one to forward it to, so I posed the problem to the users :) Thanks, though.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
find description defined datatypes
Replies
2
Views
48
peac3
peac3
rw409168
  • Locked
  • Question
SQL Server 2005 - fieldname alias issue (datatypes)
Replies
6
Views
82
markros
markros
hapax
  • Locked
  • Question
Easy command to see table column datatypes
Replies
2
Views
60
bborissov
bborissov
bessebo
  • Locked
  • Question
Need suggestions on datatypes... 1
Replies
8
Views
64
bessebo
bessebo
SQLDenis
  • Locked
  • News
SQL Server 2008 Will Have 7 New Datatypes
Replies
11
Views
67
AlexCuse
AlexCuse

Part and Inventory Search

Sponsor

Back
Top