[V4MD2] Are queries case sensitive

[Ruslan Zasukhin]

On 5/27/05 11:54 PM, "Wilk, Steven" <SWILK at ags.com> wrote:

> The reason I asked this question is because my results from my SQL query
> would indicate otherwise.  I have a WHERE clause that looks at the last name
> of "smith" I get no records returned, same query using "Smith" returns all
> of the Smiths.  Can you please explain why that would be?  Do I need to set
> the ColAttribute or something else?

Ah, you ask about if is case-sensitive searches?

And you use V4MD2. Ok.

On default yes. They are case-sensitive

Yes you can do on db creation

    db.ColAttribute( #kStrength, #kPrimary )

To make your db case insensitive

See examples     


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]