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: Tue, 9 Mar 2010 08:52:03 -0500
I would expect that your table being latin1 does not help. Try converting your table (I think the column on its own can be converted to UTF8 too IIRC) to UTF8 and see if that solves your problem.
-Kieran
PS. Gosh isn't character encoding such a pain.
On Mar 9, 2010, at 6:23 AM, John Pollard wrote:
> 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
_______________________________________________
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