Many thanks. Worked fine. Sadly, almost every one of the varchar columns I checked return near the max length. Is there still a huge performance penalty, if most of the rows come close to hitting the max of the defined varchar length? I suppose it depends on your data, and how you use it. Just curious to hear some opinions.
On Monday 22 October 2001 05:42 pm, Moshe Gurvich wrote: > 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 --------------------------------------------------------------------- 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