Hi Ray,
OK.
SQL Output: evaluateExpression:
<com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "UPDATE MENU_ITEM SET
DESCRIPTION = ?, LAST_UPDATE = ? WHERE (id = ? AND MENU_ID = ?)" withBindings:
1:"10 oz portion broile...ed Hamakua Mushrooms"(description), 2:2011-11-08
09:26:47(lastUpdate), 3:125(id), 4:4(menuID)>
Nov 08 09:26:47 KMCustomerPortal[4042] INFO er.transaction.adaptor.Exceptions
- Database Exception occured:
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed:
<com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "UPDATE MENU_ITEM SET
DESCRIPTION = ?, LAST_UPDATE = ? WHERE (id = ? AND MENU_ID = ?)" withBindings:
1:"10 oz portion broile...ed Hamakua Mushrooms"(description), 2:2011-11-08
09:26:47(lastUpdate), 3:125(id), 4:4(menuID)>:
Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect string
value: '\xE9ed Ha...' for column 'DESCRIPTION' at row 1
re: DESCRIPTION - ok, good to know. In the future I'll use one of your
suggestions.
Table structure (it's a little different now that I've tried setting the
character set on the table - I'm having the same issue with other tables but
they don't have that character set enforcement).
CREATE TABLE `MENU_ITEM` (
`CREATE_DATE` datetime DEFAULT NULL,
`DESCRIPTION` longtext CHARACTER SET utf8,
`ID` int(11) NOT NULL,
`LAST_UPDATE` datetime DEFAULT NULL,
`MENU_ID` int(11) NOT NULL,
`PICTURE_ID` int(11) DEFAULT NULL,
`POSITION` int(11) DEFAULT NULL,
`PRICE` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`TITLE` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `MENU_ITEM_PICTURE_ID_ID_FK` (`PICTURE_ID`),
KEY `MENU_ITEM_MENU_ID_id_FK` (`MENU_ID`),
CONSTRAINT `MENU_ITEM_MENU_ID_id_FK` FOREIGN KEY (`MENU_ID`) REFERENCES
`MENU_SECTION` (`id`),
CONSTRAINT `MENU_ITEM_PICTURE_ID_ID_FK` FOREIGN KEY (`PICTURE_ID`) REFERENCES
`ASSET` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
re: LONGTEXT, yes if I use é on columns that are using VARCHAR I don't have
this problem. CURIOUSLY enough if I just save é into DESCRIPTION without any
other text it works >:(
re: Java code - default encoding.
re: Platform. I'm having this problem on client and server. Client == OSX
10.7, Server == OS X 10.5 Server
WO = 5.4.3
Wunder = Yes, a recent version.
Wunder's MySQL plugin = Yes.
MySQL: mysql Ver 14.14 Distrib 5.5.15, for osx10.6 (i386) using readline 5.1
Java: java version "1.6.0_26"
Any help would be greatly appreciated.
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/archive%40mail-archive.com
This email sent to [email protected]
