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: John Pollard <email@hidden>
- Date: Tue, 9 Mar 2010 11:23:47 +0000
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@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