Hi Ramsey, Case sensitive fetch is working properly and I get proper results.
*I will try with utf8_bin.* Thanks, Sreenivasulu Arveti. On Thu, Feb 24, 2011 at 10:10 PM, Ramsey Gurley <[email protected]>wrote: > Hi Sreenivasulu, > > Try to remember to use "Reply All" and keep your replies on list (^_^) > There are many here who are much better versed in MySQL than I am. They > will probably be able to offer more insight than I am able to provide alone. > > Does a case sensitive fetch *really* work?? I believe the ci in > utf8_general_ci stands for 'case insensitive.' The number one search result > for "utf8_general_cs" gives me: > > > http://serverfault.com/questions/137415/change-collation-of-a-mysql-table-to-utf8-general-cs > > So it looks like you need to switch over to utf8_bin to get something > resembling case sensitivity. > > As for a case insensitive search, by default all MySQL queries are case > insensitive. If you do a case insensitive query in WO, the plugin for MySQL > handles this by converting your query string using UPPER. > > Ramsey > > On Feb 23, 2011, at 10:11 PM, Sreenivasulu A wrote: > > Hi Ramsey, > > It fails to fetch for all three languages. > I didn't change the default collation. > It is, > Collation: > ======= > collation_connection: *utf8_general_ci* > collation_database: latin1_swedish_ci > collation_server: latin1_swedish_ci > > Charset: > ======= > character_set_client*utf8*character_set_connectionutf8 > character_set_database latin1character_set_filesystembinary > character_set_resultsutf8character_set_serverlatin1character_set_system > utf8 > But If i execute the eo generated sqls in the database through Toad, it > fetches records from database properly. > > Will *utf8_general_ci *is a problem for getting zero records from > eomodeld? > If it is a problem, which collation I have to be use to get proper result > from eo fetch? > > Thanks, > Sreenivasulu Arveti. > > > > On Wed, Feb 23, 2011 at 10:46 PM, Ramsey Gurley <[email protected]> > wrote: > > 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] > >>> > > > > > > > -- Thanks & Regards, 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/archive%40mail-archive.com This email sent to [email protected]
