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.
11 Jul 2014
Hi Raja,
I got an soultion to this in the below link
http://stackoverflow.com/questions/2675323/mysql-load-null-values-from-csv-data/5968530#5968530
and yes BTEQ export was all fine,there was some tweaking needed at the mysql side
You must sign in to leave a comment.
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