On Tue, Jun 19, 2001 at 08:48:56AM -0700, Brian Warn wrote:
> Hello,
>
> I want to use two text columns as my primary key. From the DuBois
> book, I see that I cannot do this since my v. 3.22.32 tables are
> ISAM, and BLOB and TEXT columns cannot be indexed. Besides
> upgrading to v. 3.23+, is there any workaround to this? One column
> will simply store really long URL values (300 characters max, I'm
> guessing), and the other column stores graphic image names, probably
> 50 characters max in length. Any reason why varchar wouldn't work
> for this?
VARCHAR columns can't hold 300 characters. And there is a limit on the
size of any given index.
You really ought to consider upgrading. The version you're running is
basically unsupported anymore.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 3 days, processed 23,317,695 queries (81/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
