I have recently upgraded my mysql database to version 5.1.72 community log. I am having an issue that all my select queries are showing the columns as NULL if there is no entry added for a specific column. For exmaple I have a table table_employee and the employee name is entered as empty. When I run the select query and display the record it shows NULL instead of empty space. I am trying to get it fixed through my.ini settings in mysql. Is there any I can handle this through my.ini settings or do I have to put the conditions in my code for all the queries.
Thanks in advance