column names appears trimmed

Hi experts

I have a problem retireving columns from MSSQL database. Column names appear trimmed in array..
I am using pear DB on windows.

for eg.

$sql="Exec dbo.up_parmsel_projects ";
$arr=$db->getAll($sql,DB_FETCHMODE_ASSOC);

Array ( [Project_ID] => 1234 [CertificateCrLfsAfterAnnexIntr] => 1 [CertificateCrLfsAfterProducts_] => 10 )
see the columns "CertificateCrLfsAfterAnnexIntr" and "CertificateCrLfsAfterProducts_" these are incomplete names. On linux it works perfectly fine, without any problems.

What could be the cause and solution for this wierd problem

Hi Guys.

Any clue what going wrong.
Is it for my php settings or pear db?

Thanks in advance.

Hello Experts

Any ideas?

Is your stored procedure running fine without pear? Check that first. If that is done then you have got some problem in PEAR. Bu i think you have a problem with your stored procedure.

thanks for reply.
My stored procedure runs perfectly fine.
I have same project up and running on linux server. Over there everything works fine. It only happened when i moved it to my windows computer.
So, i guess its a problem with Pear DB on windows box.
Are there any workarounds for the same?


Is your stored procedure running fine without pear? Check that first. If that is done then you have got some problem in PEAR. Bu i think you have a problem with your stored procedure.

I mean to say, is your stored procedure running successfully in windows computer without the PEAR?

Yes. it does. without any problem.
And as i said, i successfully done this on Linux. And MSSQL server is same for both the environment.

I mean to say, is your stored procedure running successfully in windows computer without the PEAR?