Aaaah the joys of importing data from FileMaker. Repeating fields, grrrrr.
You need to do an ASCII/CHAR conversion since vertical tab is a "non-printable"
character.
select *
from accounts
where billing_address_street LIKE CONCAT("%",CHAR(11),"%")
Since this is problem a one shot deal and you are doing a full table scan anyway, just do a search and replace on the field(s). This
will convert all vertical tabs to returns.
UPDATE accounts SET billing_address_street=REPALCE(billing_address_street,
CHAR(11), CHAR(13))
----- Original Message -----
From: "Saline Erik" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Thursday, July 13, 2006 1:17 PM
Subject: Vertical Tab problem
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
