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.
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.
I got an soultion to this in the below link
and yes BTEQ export was all fine,there was some tweaking needed at the mysql side