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/archive%40mail-archive.com This email sent to [email protected]
