select bug

[kuzemsky katy]

Hello All,


VAMD 2.4.1
Windows xp
MacosX 10.4.7
Director Mx 2004


T1 = a table
F1 = varchar field
F2 = string field

F1 contains the same datas as  F2. It contains myValue for example.


On mac, no problem.
On pc, I have a problem of select

  query1 : Select * from T1 where F1 = 'myValue'				->problem
  query2 : Select * from T1 where F2 = 'myValue'				->OK
  query3 : Select * from T1 where F1 = 'myValue%'			->problem
  query4 : Select * from T1 where F1 = 'myValu%'				->OK
  query5 : Select * from T1 where substr(F1,1, 6) = 'myValue'	->OK

Query1 returns 0 result or it must return 1 result. It's the same  
thing for query3. The other queries return the right thing.

I have the same thing with the query builder of Vstudio.


Is there something wrong in query1?



Best regards,
Katy