Field Types

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
HaVoC
Forum Commoner
Posts: 83
Joined: Sat Feb 07, 2004 7:20 am
Location: Smiths Falls, CA

Field Types

Post by HaVoC »

I've tried using the field type 'text' but it just doesn't work. I can only enter 255 characters. How do I go over this limit?
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

A text column should be able to hold around 65536 chars. How have you defined/created it exactly?
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post by tim »

BLOB is another option but i think mark is on to something

(as always)
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

Here is a MySql Types Quick Reference Table. I have found this very useful:

http://kimbriggs.onza.net/Computers/Not ... types.html
Post Reply