Re: ERROR 1170: BLOB column 'Url' used in key specification without a key length
On Mon, Jan 29, 2001 at 11:48:46PM -0800, Todd Grigsby wrote: In this particular case it doesn't. I need to ensure that each URL exists only once. And it is entirely possible to have a URL with 300 characters in it. Ok, how about encoding it? Come up with a simple compression algo that uses 6 bits for every 8 bits, allowing for a-z, A-Z, slashes, dots, dashes, etc., for a total of 64 different characters. You could squeeze 341 characters into the 256. I was considering using MD5 or something similar if I need to... But I may have found a way around the problem (for now). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
Re: ERROR 1170: BLOB column 'Url' used in key specification without a key length
This underscores a problem I have found with a few asp-driven college websites. Ungodly long URLs are used to address some of their pages. When I have inquired about this, and how to tell a friend where to find particular information, I was simply informed that this was a characterisitic of the system they used. I am using URL fields, but in a few instances, I have had to look for a page with a shorter address to enter. This is not just a mysql problem; the schools with systems like this need to address the business down-side of the difficulty in doing a referral. On 29 Jan 2001, at 22:07, Jeremy D. Zawodny wrote: I have no idea what this error is trying to tell me... I have a table called "Headlines" which contains a VARCHAR(255) field called "Url". I need to store larger values in the "Url" column, so I want to convert it to TINYTEXT. ---snip--- mysql alter table Headlines modify Url TINYTEXT NOT NULL; ERROR 1170: BLOB column 'Url' used in key specification without a key length ---snip--- There is currently a unique index on the Url column. The manual states that one can have an index on a BLOB column: http://www.mysql.com/doc/B/L/BLOB.html So I don't see the problem. A search of the mail archives has turned up nothing. A search of google also turned up nothing helpful. Any ideas? This is MySQL 3.23.29. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 John Jensen 520 Goshawk Court Bakersfield, CA 93309 - 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
Re: ERROR 1170: BLOB column 'Url' used in key specification without a key length
On Mon, Jan 29, 2001 at 10:07:55PM -0800, Jeremy D. Zawodny wrote: ---snip--- mysql alter table Headlines modify Url TINYTEXT NOT NULL; ERROR 1170: BLOB column 'Url' used in key specification without a key length Oh, okay. Now I understand. The max key length is 256, so I'd need to specify a number = 256 in the index for that column. Hmm. It'd be really nice if the 256-character max key length wasn't a compile-time directive, but a run-time directive instead. Back to the drawing board a bit... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
Re: ERROR 1170: BLOB column 'Url' used in key specification without a key length
Personally speaking, if the index 256, it will lost the meaning of indexing... - Original Message - From: "Jeremy D. Zawodny" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 30, 2001 3:06 PM Subject: Re: ERROR 1170: BLOB column 'Url' used in key specification without a key length On Mon, Jan 29, 2001 at 10:07:55PM -0800, Jeremy D. Zawodny wrote: ---snip--- mysql alter table Headlines modify Url TINYTEXT NOT NULL; ERROR 1170: BLOB column 'Url' used in key specification without a key length Oh, okay. Now I understand. The max key length is 256, so I'd need to specify a number = 256 in the index for that column. Hmm. It'd be really nice if the 256-character max key length wasn't a compile-time directive, but a run-time directive instead. Back to the drawing board a bit... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 - 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