SqlSelect doesn't find text in textfield

[Bart Pietercil]

Hi Markus,

that would be :

On 23 Sep 2008, at 16:05, Markus Fraefel wrote:

>
> res = gDB.SqlSelect( "SELECT Kapitel, Lauftext, zielFrame FROM  
> Seiten_de
> WHERE lower(Kapitel) LIKE '%" &  
> Valentina.EscapeString(lower(searchTerm),1) & "%' OR
> Lauftext LIKE '%" &  Valentina.EscapeString(lower(searchTerm),1) &  
> "%'",
> #kServerSide, #kReadWrite, #kRandom )
>

But I think you really need to read up on

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documentation:vkernel:database:locale&s=collation

remember that collation can be set on each level (db, tb, field) and  
that they can override (field has precedence and so on)
I think you are after kStrength = kSecondary

hth

Bart




> Regards,
> Markus
>
> -----Original Message-----
> From: valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Thorsten  
> Hohage
> Sent: Dienstag, 23. September 2008 15:46
> To: Valentina Developers
> Subject: Re: SqlSelect doesn't find text in textfield
>
> Hi Markus,
>
>
> On 2008-09-23, at 15:34, Markus Fraefel wrote:
>
>> Another question: Searches in Valentina database seem to be case-
>> sensitive.
>> Is there a way to switch this case-sensitivity off?
>
>
> what's about using the lower() function on both site of the  
> equitation?
>
>
> regards,
>
> Thorsten Hohage
> -- 
>
> Valentina Technology Evangelist
> generic objects  GmbH - Leiter Solution Center Nord
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina