John, I am guessing that somewhere along the line the byte count is being used to calculate the width rather than the UTF8 width.
What does your jdbc connection URL look like? What does the 'SHOW CREATE TABLE <tablename>;' output for that table look like? Regards, Kieran On Mar 8, 2010, at 11:22 AM, John Pollard wrote: > Probably OT, but, is there a simple fix for the problem when saving some text > that contains special characters where the error misleadingly says the column > is too long when it isn't (using mysql mysql-standard-5.0.18-osx10.4-i686): > > Next exception:SQL Warning:01004 -- error code: 0 -- msg: Data truncation: > Data too long for column 'NAME' at row 1 > at > com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4500) > at > com.webobjects.eoaccess.EODatabaseContext.performChanges(EODatabaseContext.java:6212) > at > com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376) > at > com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3176) > > inserting some text like: L?kensgård > > What is my best plan of attach. I have done some googling and have ended up > being very confused. > > Thanks > John _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.com > > This email sent to kieran_li...@mac.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
