paradox and php via odbc

Hello,

sorry if it is not the good NG.

I have a little problem concerning querying a paradox 7 (yes tou read
weel) db via php and odbc.
For this I use the microsoft paradox driver, the only one I have.

I have the following computers:
- S1 w2k server
- S2 2003 server, over a vmware
- P1 xp sp2

all running apache 2.0.59 and php 5.2.1

please consider the following queries and their results on the different
computers:

select Code from corrcli where Code like 'faur%'
S1: nothing
S2: a list of codes beginning by FAUR
P1: nothing

select Code from corrcli where Code like 'FAUR%'
S1, S2: the same list of codes beginning by FAUR
P1: nothing

select Code from corrcli where Code like '%FAUR%'
S1, S2, P1: the same list of codes comprising FAUR

well...

how to fixe this behaviour ? If the answer is:" change the driver...",
for which one (free if possible).

thanks in advance

thierry

Hello

Have a look here, in french for you !
http://www.clairinfo.fr/scripts/trace.php?noart=6

(English version : http://www.clairinfo.fr/fichiers/Php_Paradox_English.pdf)

and the short answer is : use UPPER in the query (but not for a memo...)

SELECT * FROM MyTable WHERE UPPER(MyField) LIKE 'TOTO%'

Hth Côme

"thierry" a écrit dans le message de
47bc5fb5$0$9722$426a74cc@news.free.fr...
> Hello,
>
> sorry if it is not the good NG.
[...]