I changed the default character set on a 4.1 server to utf8.
As expected, this caused the lengths of character fields to be
shortened, requiring alter table to be run on them to extend the
lengths.
But I didn't expect that this would also shorten the mysql system
tables (the "mysql" db), so that usernames for newly inserted users
have been truncated to fit the next field lengths.
Is this a known issue?
Should I set the character set for the mysql db back to latin1?
Running "alter table" on the mysql tables to extend all of the column
lengths seems like a bad idea, but seems like what's recommended for
other tables in the manual.
Also, on a related note, these are really big tables, and running
alter table on them to modify the column lengths is taking a LOOONG
time. Any hints on speeding this up?
--
- Adam
** I can fix your database problems: http://www.everylastounce.com/mysql.html **
Blog............... [ http://www.aquick.org/blog ]
Links.............. [ http://del.icio.us/fields ]
Photos............. [ http://www.aquick.org/photoblog ]
Experience......... [ http://www.adamfields.com/resume.html ]
Product Reviews: .. [ http://www.buyadam.com/blog ]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
