We recently exported data from Filemaker then imported into mySQL
4.0.22. The data shows up in mySQL queries just fine. But when we
use our PHP based Web App it shows little boxes in the data.
The little box is a Vertical Tab that Filemaker uses. The Ascii is
11 or 0xb or sometimes known as \v.
What I am trying to do is a replace of the little boxes with a space
or something.
I can not get the query to find the records with the Vertical Tab in it.
I tried:
select *
from accounts
where billing_address_street LIKE "%\v%"
That returns everything with the letter v in it.
Any ideas would be great.
Erik
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
