[RESOLVED] MySQL is reading this differently than MSSQL

Square1

Hi all:

Not quite sure if this is a database issue or a PHP code issue.

I have a MySQL database and a MSSQL database (I am converting from ASP classic to PHP).

The following text is in a record on both databases. It is entered in the field just as you see it below by copying and pasting off of a web page:

The Pirates have moved their annual PirateFest indoor event up a month to December, meaning that tickets for the 2012 season will be available before the end of this year.

The event will still span three days, with the Friday, Dec. 16, session set aside for season-ticket holders only. The indoor carnival will be open to everyone else on Saturday, Dec. 17 (10 a.m.-7 p.m. ET), and Sunday, Dec. 18 (12 p.m.-5 p.m.). It will once again be held at the David L. Lawrence Convention Center in downtown Pittsburgh.

Note that there is no html, no <p>, no <br> etc. Just pure text.

On the ASP page using MSSQL the information reads just as it is shown above. 2 paragraphs with a line break between them. Yet on MySQL it reads as a giant run on sentence:

The Pirates have moved their annual PirateFest indoor event up a month to December, meaning that tickets for the 2012 season will be available before the end of this year. The event will still span three days, with the Friday, Dec. 16, session set aside for season-ticket holders only. The indoor carnival will be open to everyone else on Saturday, Dec. 17 (10 a.m.-7 p.m. ET), and Sunday, Dec. 18 (12 p.m.-5 p.m.). It will once again be held at the David L. Lawrence Convention Center in downtown Pittsburgh.

I prefer the MSSQL way!

On MySQL that field is set as varchar. On MSSQL it is set as nvarchar. Is there any setting in PHP so it reads with the breaks as it does using the MSSQL DB with ASP?

Thanks!

bradgrafelman

It has nothing to do with how the text is "read" as that never changes.

Regular line breaks have no effect on content rendered as HTML, however, since whitespace in HTML is ignored by your browser. If you want it to be preserved, then you need to use something like [man]nl2br/man to turn those line breaks (which are still being sent as output - are you looking at the raw source of the page returned or simply relying on your browser to render the data without actually checking it?) into <br> HTML entities.

Square1

bradgrafelman;10992092 wrote:
It has nothing to do with how the text is "read" as that never changes.

Regular line breaks have no effect on content rendered as HTML, however, since whitespace in HTML is ignored by your browser. If you want it to be preserved, then you need to use something like [man]nl2br/man to turn those line breaks (which are still being sent as output - are you looking at the raw source of the page returned or simply relying on your browser to render the data without actually checking it?) into <br> HTML entities.

Perfect. nl2br() was the answer! Thank you