Have you changed MySQL's default collation to a case sensitive utf8 collation? Does it fail in all three languages or just for the non-english fetches?
Ramsey On Feb 23, 2011, at 9:48 AM, Sreenivasulu A wrote: > Hi Ramsey, > > Case sensitive fetch is working properly. > I am using MySQL Database. > > Thanks, > Sreenivasulu Arveti. > > > > On Wed, Feb 23, 2011 at 10:05 PM, Ramsey Gurley <[email protected]> > wrote: >> Hi Sreenivasulu, >> Not really sure... All other things being equal, does a case sensitive fetch >> work? Also, what DB are you using? >> Ramsey >> On Feb 23, 2011, at 2:14 AM, Sreenivasulu A wrote: >> >> Hi All, >> >> I am implementing internationalization in my example application. >> For doing this, I kept Schema is in utf-8. >> >> Entitiy in EOModeled as shown below: >> >> { >> attributes = ( >> { >> allowsNull = N; >> columnName = id; >> name = id; >> precision = 10; >> prototypeName = "a_id"; >> }, >> { >> columnName = "student_name"; >> name = "student_name"; >> prototypeName = "a_text"; >> userInfo = { >> ERXLanguages = ("en_us", "ms_my", "zh_cn"); >> }; >> valueType = E; >> width = 255; >> } >> ); >> attributesUsedForLocking = (id, "student_name"); >> className = Student; >> classProperties = ("student_name"); >> externalName = student; >> fetchSpecificationDictionary = {}; >> name = Student; >> primaryKeyAttributes = (id); >> } >> >> All these are working properly. Reading from, writing to Schema is working >> properly for english, malay and chinese languages. >> >> But caseInsensitive eo fetch is not giving result on 'student_name column'. >> >> If the 'valueType = S' then it is giving proper result, but writing data to >> Schema(DB) is not working. >> >> If the 'valueType = E' then writing data to Schema is working, but >> caseInsensitive fetch is fail to give proper result. >> >> Any help could be greatly appreciated. >> Thanks in advance, >> Sreenivasulu Arveti. >> _______________________________________________ >> 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/rgurley%40smarthealth.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]
