All Forums General
10 Apr 2014
Treating NULL from bteq export

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

 

Raja_KT 1246 posts Joined 07/09
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.