Gino, first thing I would try would be to log out the generated SQL and check its contents. Can you do that?
Unless I am missing something, your quoted strings look like a plain ASCII, and thus they should not be affected by Unicode quirks. All the best, OC > On 14 Jan 2020, at 15:26, Gino Pacitti via Webobjects-dev > <webobjects-dev@lists.apple.com> wrote: > > Still not working …. > > Could it be the length of the string? > > This is the searched for String - pi_1G0qENIo1HLeQd0O7rTZlOAx > > This is the database Varchar - pi_1G0qENIo1HLeQd0O7rTZlOAx > > I have this in my connection Dictionary - > useUnicode=true&characterEncoding=UTF-8 > > The database is configured for UTF-8 and the column has this Collation - > utf8_general_ci > > The search for string is returned from a POJO > > Any other ideas? > > > > > > > > > >> On 14 Jan 2020, at 12:59, Gino Pacitti via Webobjects-dev >> <webobjects-dev@lists.apple.com> wrote: >> >> Thanks Pierre >> >> I will test this out… >> >> >> >>> On 14 Jan 2020, at 12:57, GILQUIN Pierre <pierre.gilq...@hcuge.ch> wrote: >>> >>> Yes strange >>> >>> A case issue ? May be try Transaction.PAYMENTINTENTID.ilike() >>> Or a encoding utf8/iso issue … >>> >>> >>> >>> De : Webobjects-dev >>> [mailto:webobjects-dev-bounces+pierre.gilquin=hcuge...@lists.apple.com] De >>> la part de Gino Pacitti via Webobjects-dev >>> Envoyé : mardi 14 janvier 2020 13:34 >>> À : WebObjects-Dev Mailing List List >>> Objet : Re: Failed Query >>> >>> Thanks I will give it a go… >>> >>> Funny thing is that the ‘old’ code works and then just on occasion does not… >>> >>> >>> >>> >>> >>> >>> On 14 Jan 2020, at 12:25, GILQUIN Pierre via Webobjects-dev >>> <webobjects-dev@lists.apple.com> wrote: >>> >>> Hi, >>> >>> I Dont know if your old style qualifier is correct, so you may try >>> something like this with the corresponding ERXKey : >>> myQual = Transaction.PAYMENTINTENTID.eq(paymentIntentID) ; >>> >>> De : Webobjects-dev >>> [mailto:webobjects-dev-bounces+pierre.gilquin=hcuge...@lists.apple.com] De >>> la part de Gino Pacitti via Webobjects-dev >>> Envoyé : mardi 14 janvier 2020 13:04 >>> À : WebObjects-Dev Mailing List List >>> Objet : Failed Query >>> >>> Hi >>> Anyone had experience of queries that should return an object as the row >>> exists but EOF throws a NoSuchElementException? >>> >>> This is some code: >>> >>> >>> Transaction transactionEo = >>> QueryDatabase.TransactionForPaymentIntentIdQuery(customCharge.getPayment_intent(), >>> _ec); >>> >>> >>> public static synchronized Transaction >>> TransactionForPaymentIntentIdQuery(String paymentIntentID, EOEditingContext >>> _ec) throws NoSuchElementException { >>> >>> >>> NSArray<String> args = new NSArray<String>(new String[]{ >>> paymentIntentID }); >>> EOQualifier myQual = >>> EOQualifier.qualifierWithQualifierFormat("purchaseIntentId = %@", args); >>> >>> log.info("Qualifier " + myQual); >>> >>> >>> return Transaction.fetchRequiredTransaction(_ec, myQual); >>> >>> } >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> https://lists.apple.com/mailman/options/webobjects-dev/ginokris%40mac.com >>> >>> This email sent to ginok...@mac.com >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/ginokris%40mac.com >> >> This email sent to ginok...@mac.com > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/ocs%40ocs.cz > > This email sent to o...@ocs.cz _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
