New Line Issue

Hi, I have an update query eg :

UPDATE <table_name> q SET q.<column_name> = '<Certain Text_1> <Certain Text_2>' where q.<column_name> = 'XXX' and q.<column_name> = XXX;

When I execute it on my local environment (Heidi) --->the results shows Certain Text_2 on a new line, whereas when I execute the same query on the production environment(Heidi) ---> the result shows Certain Text_2 on the same line stuck with Certain Text_1.

Why such discrepancy?