10 Apr 2014
I feel that bteq export is fine. I think you use load data infile ....in mysql. where you may need to check the script......
If I am not wrong \N is represented for NULL in mysql. Do you need to have then .SET NULL AS 'NULL' ? I am not sure, since you set SESSION CHARSET set to UTF8. Have not seen the data.
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.
Hi ,
I am facing problem when i upload files exported using bteq into MYSQL
with .SET SESSION CHARSET set to UTF8
.SET NULL AS 'NULL'
the problem mysql reads NULL as 'NULL ' so falls over
any help on this would be great.
Thank you