Treating NULL from bteq export

General
Enthusiast

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


Tags (3)
2 REPLIES
Enthusiast

Re: Treating NULL from bteq export

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.

Enthusiast

Re: Treating NULL from bteq export

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