OK, After googling for a while I was able to figure it out. There was a bug in the JDBC adapter and I was using an outdated version. I upgraded to mysql-connector-java-5.1.18-bin and the problem went away.
Yay! Johnny Miller Kahalawai Media Corp. www.kahalawai.com On Nov 8, 2011, at 10:45 AM, Chuck Hill wrote: > In UTF-8 é is two "characters" in length (I think). You need to allow extra > space in the database columns > > > On 2011-11-08, at 12:19 PM, Johnny Miller wrote: > >> OK, >> >> this is getting stranger by the moment. >> >> This string works: >> 10 oz portion broiled with Buzzs Season Sautéed Hamakua Mushroom >> >> And this string works: >> 10 oz portion broiled with Buzzs Season Sauteed Hamakua Mushrooms >> >> This string does not work: >> 10 oz portion broiled with Buzzs Season Sautéed Hamakua Mushrooms >> >> The difference being that the last string contains the é and is one >> character longer than the first string. If I add the character anywhere >> else it also fails. >> >> Johnny Miller >> Kahalawai Media Corp. >> www.kahalawai.com >> >> >> >> On Nov 8, 2011, at 7:56 AM, Ray Kiddy wrote: >> >>> >>> On Nov 7, 2011, at 10:48 PM, Johnny Miller wrote: >>> >>>> Hi >>>> >>>> I'm getting an com.webobjects.eoaccess.EOGeneralAdaptorException (-- error >>>> code: 1366 -- msg: Incorrect string value: '\xE9ed Ha...' for column >>>> 'DESCRIPTION' at row 1) when savings characters like é. I'm using a MySQL >>>> database 5.5 with the encoding set to UTF-8 unicode and the collation set >>>> to utf8_general_ci. The encoding and collation settings on the table and >>>> column appear to match the database. And this issue seems to only effect >>>> columns using the type LONGTEXT. >>>> >>>> Can someone point me to where I have gone wrong? >>>> >>>> Thank you, >>>> >>>> Johnny Miller _______________________________________________ >>> >>> Can you send SQL output, from setting EOAdaptorDebugEnabled? >>> >>> The fact that you are using a column named "DESCRIPTION" is making me >>> uncomfortable. It may be fine. In the old days, there were vestiges of the >>> Objective-C tools hanging around and it would have been very bad to get in >>> the way of NSObject's [description] method. We are probably past needing to >>> worry about, though. Still. And you cannot use "DESC" since that is a MySQL >>> keyword. I usually use "note" or "annotation" or something like that for a >>> "description" column. >>> >>> This might end up being a really great test case. Can you send in some >>> version of your table create statements? I could try to reproduce the >>> problem. I have not had cause to use LONGTEXT specifically. Does the >>> problem not occur when using some other, similar data types? I would be >>> curious if the MySQL forums say anything about LONGTEXT in particular. >>> >>> What encoding are you using for strings in your java code? Is it the >>> default encoding? What platform are you on? The default encoding is >>> different for Mac OS X than for Linux versions and (I would assume) for >>> different Windows versions. >>> >>> The question is also going to be asked: Which version of WO are you using? >>> Are you also using Wonder? Which MySQL plugin are you using? WO's or >>> Wonder's? >>> >>> I have had to learn entirely too much about encodings and all the ways this >>> can get screwed up in the last few months. I would not want to do a brain >>> dump of all that crap on the list, but we can talk off-list if it would >>> help. >>> >>> cheers - ray >>> >>> _______________________________________________ >>> 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/jlmiller%40kahalawai.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/chill%40global-village.net >> >> This email sent to [email protected] > > -- > Chuck Hill Senior Consultant / VP Development > > Practical WebObjects - for developers who want to increase their overall > knowledge of WebObjects or who are trying to solve specific problems. > http://www.global-village.net/products/practical_webobjects > > > > > > >
_______________________________________________ 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]
