[V4RB2] Different results for search between Valentina and MySQL

[Ruslan Zasukhin]

On 4/8/05 7:45 AM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

> I am able to run a search that yields different results in Valentina and
> MySQL, and I don't know which one is doing it correctly (although I think
> it's MySQL).
> 
> If I have the zip codes 10597 and 10579, MySQL will find both if I use fld
> LIKE '105%9%' and Valentina will find only 10579 if I use fld.FindLike(
> "105%9%" ).
> 
> Is this a bug in Valentina, MySQL, or just different implementations of SQL?

Ivan,

Please check this issue and inform us.
Test it also on MS and Sybase.


-- 
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]