Jump to content


This topic is now archived and is closed to further replies.

Darkness Soul

Exporting files

Recommended Posts


Well, this time, something new (to me)..

I was reading a file to export it to db, and the file have a textarea with some \n, \t, \n\t, \t\n, (...).
I want to write it in a blob in the db.. but.. its export wrong..

I've tried to use ltrim, rtrim, trim, but its only remove left and right .. not int the middle..

So, i've seen the preg_replace in the documentation, but ive never saw it before..

Someone help me?



Share this post

Link to post
Share on other sites
you mention textarea, so i can only assume it's text you want to store in the DB. the TEXT type, as opposed to BLOB, is more than capable of storing lots of text, even as far as an entire text file.


Share this post

Link to post
Share on other sites
I think I don't told that clear.. (mine bad english x] )

I have one DB in the server X, I have to read the data and write into the DB at server H.

So, I export it to a [data.txt] file, because I need to rewrite some data and turn it compatible with the new DB.

The "textarea" i've been said is just a BLOB in the old DB, but when i write it in the file, this write with that \n and \t characters.

I export the file, read and replace the adaptations, and import to new DB, in theory.

This old-blob give me a headshake with itself string.. I need to replace the \n for new lines to write and lost the \t (tabs), so I can write it into the new-blob..

Clean now? sorry for bad sentences.. ^^"!


Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.