Re: Data too long for column (not really)
Re: Data too long for column (not really)
- Subject: Re: Data too long for column (not really)
- From: Kieran Kelleher <email@hidden>
- Date: Mon, 8 Mar 2010 12:18:02 -0500
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@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden