V4MD "Search a string case insensitive ..."

[Heinrich Ruoff]

Hi Paolo,

to make your db case insensitive in general try
gDb.setCollationAttribute(#kStrength, #kPrimary)
before adding tables and fields.

Heinrich

On 7/9/05, Erik Scholtz <anomar at elitecoderz.net> wrote:
> info at vallemediatime.com wrote:
> > I try to ask again...
> > It's so hard to answer?  :-)
> > Paolo
> >
> > ----- Original Message -----
> > From: <info at vallemediatime.com>
> > To: "Valentina Developers" <valentina at lists.macserve.net>
> > Sent: Friday, July 08, 2005 11:55 AM
> > Subject: V4MD "Search a string case insensitive ..."
> >
> >
> > Hi Ruslan and Igor,
> > I've not found the request example (Mantis #881)
> > "Search a string case insensitive in all one table in V4MD"
> > where have you put it?
> > Thanks
> >
> > Paolo
> 
> Hi,
> 
> I don't know where the example is, but try something like this:
> 
> SELECT col1,col2,col3
> FROM table
> WHERE LOWER(column4)=LOWER('seArchString')
> 
> This will make the search case-insensitive. Perhaps there is an option
> on valentina I don't know, but I think this is a easy, working way.
> 
> Best regards,
> Erik
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>