[development] Form field maxlengths vs. database field sizes
Piotr Krukowiecki
piotr at mallorn.ii.uj.edu.pl
Sun Feb 12 08:40:52 UTC 2006
On Sun, Feb 12, 2006 at 01:43:57PM +0530, Karthik wrote:
> How about pgSQL?
Postgres counts in characters.
[Sidenote]
Furthermore, there's no difference in performance between
char/varchar/text and I've changed several columns from varchar(n) to
text in cases where data was of unknown lenght (e.g. referrer, url etc).
I've left other columns unchanged because I didn't want to drift away
from mysql version too much, but I'd prefer to change (almost) all
columns for user-supplied data (e.g. node title comes to mind) to
unlimited lenght... I don't see why we should limit user and say how
long his title can be.
--
Piotrek
irc: #debian.pl
Mors Drosophilis melanogastribus!
More information about the development
mailing list