possible bug?

[Ivan Smahin]

Hello Joseph,

Wednesday, April 9, 2008, 7:24:42 AM, you wrote:

> Hi,

> Please look at the following query:

> select _rowID from customers where accountName = 'Sample1'

> _rowID is a long
> accountName is VarChar, Text, or String (it doesn't seem to mater)

> This query always returns nothing even though I know the record exists.

> The problem seems to happen on any query with a WHERE statement that  
> looks at a field with some text in it.

> I think I may have brought this up before and at the time just  
> switching to another
> field type. But now, all the field types give me the same problem.

> Is this a bug?

Could you diagnose database firstly?
Do you have any specific collator settings for this field?
Do you have Index-By-Words on this field?

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com