In my database (Interbase) i have an field name Address with BLOB type. When I echoing it out using PHP, it looks strange like : H|ݨ|Ý…ÿ while the real data is : Jl. Lebak Bulus I / 18
What is wrong with BLOB type ? Ika
It's binary data. That's what BLOB means... Binary Large OBject
You shouldn't use blob types unless you absolutely have to. (for um...binary data)
ic, but the database has already been set up and contains thousand of records. Any chance to convert it by php ???
One idea is to add a column called something like column_fixed...
Then loop through each record and using something like this...
SELECT badcolumn FROM table into DUMPFILE "/tmp/file.txt"
Then read the file and insert each record into column_fixed.
