[PHPwestoz] [OT] MySQL UNIQUE INDEX

[Timothy White]

Mike Fewings wrote:

> Timothy,
>
> If you are wanting to place a limit on the text column, try VARCHAR
> and limit that.

What's the difference between VARCHAR and TEXT? I got it to work using
Mark's suggestion as I had already created the table without the key and
just added (using mysql-navigator and customising the query) the Unique
index later.

Tim

--
Tim White - Use the Fox, Luke!
PGP/GPG id: 602E944D, Pub Key Serv: subkeys.pgp.net
Fingerprint: 04C2 9682 B7B2 3006 009D  A9F3 067E EDCD 602E 944D
Hi! I'm a .signature virus! Copy me into your ~/.signature to help me spread!
--

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
Url : http://lists.linux.org.au/pipermail/phpwestoz/attachments/20050221/1aaf34c0/attachment.pgp