Hi Prasad,<br><br>Thanks for the reply. I have dumped the database and this is what I get for the field. Please look at the attached jpg to see the screen shots. <br><br>"leadid";"cf_450";"cf_452";"cf_454";"cf_456"<br>
"22";"1";"0";;"15 Weeks"<br><br>BTW, When I translate the "15 Weeks" into hex, I get the following:<br>%31%35%20%20%57%65%65%6B%73<br><br>It seems that the + sign is replaced with a space (a test I was sure I tried) but with that knowledge it seems to be working ... I now search for "15[space][space]Weeks" and I find my records.<br>
<br>--Stephen<br><br><div class="gmail_quote">On Tue, Jan 13, 2009 at 1:34 AM, Prasad <span dir="ltr"><<a href="mailto:prasad@vtiger.com">prasad@vtiger.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Stephen,<br><br>Can you share a screenshot of the issue being pointed in vtiger CRM?<br><br>Regards,<br>Prasad<br>vtiger Team<br><br><div><div><div></div><div class="Wj3C7c"><span class="gmail_quote">On 1/13/09, <b class="gmail_sendername">Stephen Mack</b> <<a href="mailto:stephen@trax.cl" target="_blank">stephen@trax.cl</a>> wrote:</span></div>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="Wj3C7c">
I have a custom picklist field in the lead database (actually it's stored in the vtiger.leadscf database). I use the phpmyadmin to view the data and the + sign is not there (although when I use vtiger it's displayed correctly).<br>
<br>My problem is that when I access the database directly to do searches, I can't find the records. I suspect that a special "non printable" character is being inserted.<br><br>What might that character be?<br clear="all">
<span>
<br>--Stephen<br>
</span><br></div></div>_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br>
<br>_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br><br clear="all"><br>-- <br>--Stephen<br>