HELP! Carriage returns from ACCESS to SQL to PHP missing!

[sledgeweb]

Hello-

OK, here's the deal: I'm in the process of taking over an outside website into our company. The website used an access database to store NEWS items. I've run a data transformation process to transfer the data in the ACCESS DATABASE to our MS-SQL database.

When I pull the information out of SQL and into PHP and display it on a web page, there is no carriage returns where they previously appeared on the clients site while pulling from the ACCESS DATABASE!

How can I get the carriage returns to appear? What exactly is going on here? I'm sure its just a case of ACCESS and SQL and PHP recognizing carriage returns differently, but how can I resolve this?

Also, on some of the really LONG articles in the news items, I've found that the text gets cut off after so many characters in the SQL table, even though it is set to TEXT. Any ideas on this?

Please help! I'm a little behind on this project...

Thanks!,
Sledge

[ChrisJ-UK]

Depending on how long a long article is, it can be the server settings interrupting long communications.

The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you can actually transmit between the client and server is determined by the amount of available memory and the size of the communications buffers. You can change the message buffer size (max_allowed_packet), but you must do so on both the server and client ends. See section 7.5.2 Tuning Server Parameters.

MySQL Manual

Parameters7.5.2 Tuning Server Parameters

[sledgeweb]

Hmmm, thanks, but I'm not using MY-sql. If you read above, you'll see that I'm using MS-SQL.

So, does this still apply?

[ChrisJ-UK]

Yeah, sorry.

Read MS-SQL as My-SQL.

Got MySQL on the brain I guess.

Chris