HI,
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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.