All Forums Tools
kiran_terydata 13 posts Joined 09/09
10 Sep 2009
I am loading the data into files using fastexport but...

HiI am loading the data into files using fastexport but the data is in binary format eventhough i am using text format, please send me a sample script to load the data into tables in a text format.Thankskiran

Raja_KT 1246 posts Joined 07/09
10 Sep 2009

Use mode record and format binary.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

feinholz 1234 posts Joined 05/08
10 Sep 2009

If the layout of the table consists of non-character fields (i.e. integer, decimal) then the datawill be returned to FastExport in binary format.If you want the data in text format, then you would need to CAST your columns to CHAR or VARCHAR.

--SteveF

You must sign in to leave a comment.