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]
