select max(length(column)) from table -----Original Message----- From: Tony [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 2:36 PM To: [EMAIL PROTECTED] Subject: Oracle conversion...
Is there a quick and easy way to determine the maximum used length of a varchar column? I've built and imported an Oracle DB into a MySQL one and now I'd like to greatly reduce the number of varchars that were being used in the original (e.g. Oracle) DB on my MySQL version. I am digging into the manual, but time savings would be greatly appreciated. Regards, Tony --------------------------------------------------------------------- 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001 --------------------------------------------------------------------- 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
