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
How about desc_ ?
Erik
On Jul 13, 2006, at 8:42 AM, Anthony wrote:
Hello,
i want to know how i can create a table with the feild name desc ?
when i do:
CREATE TABLE bank (
name varchar(50) NOT NULL default '',
desc varchar(50) NOT NULL default '',
)
the desc is badely interpreted...
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