On 5/29/07, Stephen Barncard <[EMAIL PROTECTED]> wrote:
For accessing and uploading data there's CocoaMySQL for the Mac. Many others for PC. new beta
http://cocoamysql.sourceforge.net/beta/CocoaMySQL_0.7b5.zip I've been using CocoaMySQL-SBG 0.7.1 and love it. Don't know what the SBG is about so downloaded the above to see which is the latest and discovered a HUGE BUG in 0.7b5. 0.7b5 is 'more up to date' than SBG 0.7.1, it's got more colour, has extra features and the data presentation is way more efficient; BUT if you have any VARCHAR columns (haven't tested anything else) larger than 100 char you risk having your data truncated to 100 char and the data in other columns mangled! You may need to download CocoaMySQL-SBG 0.7.1 or some other data viewing app to test this: http://www.theonline.org/cocoamysql/ To test, COPY an existing DB that has VARCHAR >100 column. DO NOT USE A WORKING DB!!!!!!!!!! I'm going to assume the VARCHAR column is called "remarks" 1) In 0.7b5 view the 'remarks' column. To start with you'll note that the initial data is displayed with a ellipsis [three dots which is a single char] at the end. Widen the column as much as possible. The data will now be displayed with (...) [not an ellipsis but three periods enclosed in brackets] at the end, even though there might be space at the right side of the column to display more text. ie char 101 to 105 is (...) 2) Add a new row. Type in data where necessary, and in the remarks column make sure you exceed 105 char. Tab out of the column and it will be truncated with (...). If you have to add data to other columns in your DB, do so, BUT DO NOT GO BACK to the 'remarks' column. Once you've entered all the data click in another row so that you know the row has been written and there are no errors. 3) Quit 0.7b5 and Open SBG 0.7.1. Go to the last row in your DB and widen the remarks column and you'll see all the data is displayed correctly and can be edited if necessary. Quit SBG 0.7.1 4) Open 0.7b5 and go to your DB and the last row. Tab through the field to the 'remarks' column as if you wanted to edit it. Note that your data ends with (...), and hasn't been replace with the full data. Click another row so that you haven't changed any data in the last row. 5) Quit 0.7b5 and Open SBG 0.7.1. Go to the last row in your DB and you'll see that the remarks column now ends with (...). Your data is GONE! ALSO, check other columns, in my case columns 2 thru 5, which in my case are decimal columns of various sizes, were overwritten with 99.9 thru 99999.9depending on the max size of the column. I'd steer way clear of 0.7b5. I'm using this on: MacBook Pro Intel CD 2GHz 1GB RAM OSX 10.4.9 MySQL 5.0.27 No problems with CocoaMySQL-SBG 0.7.1 _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
