Hello Dear VbForums Team!
Please help me to solve this issue.

I am using Mysql and ADO recordset to connect to MySql.

I am creating customizable search engine in vb6 and during my query modification now as result I receive "???????" values in some columns.
However when I tried same query in php everything worked correct and I was able to see correct field values.

Please advice,why I see ?????? values instead of real values ?

Here is my query:

set @match = '^(([0-9+-.$]{1})|([+-]?[$]?[0-9]*(([.]{1}[0-9]*)|([.]?[0-9]+))))$'

After next part of query:

Select if(tblclientmaster.ClientId regexp @match,if(Count(Distinct tblclientmaster.ClientId)=1,tblclientmaster.ClientId,SUM(tblclientmaster.ClientId)),if(Count(tblclie ntmaster.ClientId)=1,tblclientmaster.ClientId,if(Count(Distinct tblclientmaster.ClientId)=1,tblclientmaster.ClientId,Concat(Count(tblclientmaster.ClientId),"" (count)"")))),if(tblclientmaster.ClientName regexp @match,if(Count(Distinct tblclientmaster.ClientName)=1,tblclientmaster.ClientName,SUM(tblclientmaster.ClientName)),if(Count(t blclientmaster.ClientName)=1,tblclientmaster.ClientName,if(Count(Distinct tblclientmaster.ClientName)=1,tblclientmaster.ClientName,Concat(Count(tblclientmaster.ClientName),"" (count)"")))) from tblclientmaster Group by tblclientmaster.ClientType


In Php everything is ok in vb6 I get "?????" in all ClientId fields and blank field values in ClientName field,however on php everything is showing normally.

Kind Regards,
S0LARIS.