Login to mysql Perform this on the table ALTER TABLE tbl-name MODIFY COLUMN Rating varchar(10); Then recreate the ODBC link in OpenOffice Give it a try.
Colleen Beamer <[EMAIL PROTECTED]> wrote: Hi, I apologize for posting here, because I only use MySQL at a very basic level - I wanted to create an Access-like database and found that I could use Open Office with an ODBC connection to a MySQL database to do what I wanted. Up to this point all has been fine. However, I just upgraded to MySQL 5.0.4 (the latest version available for Gentoo) and my column widths have been screwed up. I've looked in the reference material that I have and googled, but didn't find anything to specifically tell me how to (or if I could) change the column width in a table. For instance, I have a column called Rating which *was* varchar(10) and after the upgrade it's now varchar(3). Is there an easy way to change the column widths without having to recreate the table? Regards, Colleen -- Registered Linux User #411143 with the Linux Counter, http://counter.li.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --------------------------------- Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games.
