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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySql Data Types

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
I am trying to setup a table in a MySql DB. What is the equivalent of a varchar(4000) in MySql? I need a data type that will handle longer strings than 255 bits.
 
Sort by date Sort by votes
Hiya,

I think that the data type you need is TEXT. This should allow you up to 2,048 bytes (or characters).

Tim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

LuciusThorne
  • Locked
  • Question Question
Database Design - Reusing one-to-many relationship in a table?
Replies
4
Views
878
mintjulep
M
dwf1962
  • Locked
  • Question Question
Trying to write a simple Foxpro prog to convert database of probabilities to a life expectancy table
Replies
1
Views
663
SkipVought
S
andy_sem
  • Locked
  • Question Question
.mdb database problem
Replies
2
Views
571
mmmacoss
mmmacoss
oxicottin
  • Locked
  • Question Question
Visual Work Instruction Database (VWI) Design
Replies
3
Views
596
Olaf Doschke
Olaf Doschke
ReCycled
  • Locked
  • Question Question
"Best practice" design to input data into detail table
Replies
4
Views
593
ReCycled
ReCycled

Part and Inventory Search

Sponsor

Back
Top