Re: CaseInsensitive fetch results to ZERO records....
Re: CaseInsensitive fetch results to ZERO records....
- Subject: Re: CaseInsensitive fetch results to ZERO records....
- From: Ramsey Gurley <email@hidden>
- Date: Wed, 23 Feb 2011 10:16:00 -0700
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@hidden> 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@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden