Hi Kieran, connection URL (development environment but will be essentially the same in deployment):
jdbc:mysql://localhost/MPDB2?user=admin&capitalizeTypeNames=true&useUnicode=true&characterEncoding=UTF-8 SHOW CREATE TABLE: CREATE TABLE `Organisation` ( ...... `NAME` varchar(128) NOT NULL default '', ...... ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Regards, John On 8 Mar 2010, at 17:18, Kieran Kelleher wrote: > 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 ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.com >> >> This email sent to [email protected] > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
