// Here's a simple test - directly at js9-level (without SQLite) - which gives proof to the phenomenon, as I observed it: //

Sorry for the delay, Olaf. I could get time to check out your code just a while ago only. Yes, I could observe the phenomenon at my end. THANK you.

For SQL queries also, 'Search' is returning 50K records only now (as UDF in SqlQuery). What made it return 25K records earlier, I don't know.
As far as "Test' is concerned, it is also returning 50K records only (as UDF in SqlQuery). It is returning correct records for non-English database also, always.

I shall have options to test both ways. If ever I encounter 25K records in my future tests at any time, I shall let you know.

Thanks thanks thanks again, Olaf, for taking the time to educate me, coming down to my level (as you always do). Ever thankful.

Kind Regards.