Jump to content

better field type for table

- - - - -
Started by lol33d, Aug 25 2011 11:11 PM

  • Please log in to reply
2 replies to this topic

#1
lol33d
Posted 25 August 2011 - 11:11 PM

lol33d

    Programmer

  • Members
  • PipPipPipPip
  • 149 posts
hi guys

my string length is 3000 FIX

what is better mysql field type for this?

varchar(3000) ?


help please

thank you

#2
Vaielab
Posted 26 August 2011 - 04:06 AM

Vaielab

    Programming God

  • Members
  • PipPipPipPipPipPipPip
  • 547 posts
You can use the type "text"

#3
grisha
Posted 29 August 2011 - 11:05 PM

grisha

    Learning Programmer

  • Members
  • PipPipPip
  • 35 posts
The TEXT, MEDIUMTEXT and LONGTEXT types can hold a lot of data, thus meet more requirements than specified lenght VARCHAR fields.

Here's something useful:
MySQL :: MySQL 5.0 Reference Manual :: 10.5 Data Type Storage Requirements
Back to PHP Development


1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users



  1. CODECALL Programming Forum
  2. → Web Development Forum
  3. → PHP Development
IPB skins by Skinbox