Not sure if this is the best place to post but it has to do with web site design etc so Ill post here.
I am using MySQL and I tried this with SQL Server to. I would like to insert an article / text into an application like phpmyadmin.
Well in ASP.Net, I can connect to the database fine, except once I select * from the table, it only shows the first line of content. In other words, you can not use a carriage return in a database. This makes no sense. I do not see any documenation about this problem and have been looking forever.
This is a problem I would think everyone who uses DBs would have being that I just started using them and it was the first problem I ran into.
In other words, an example would be, go somewhere and copy text and paste it into your table in phpmyadmin or a cell in SQL Server. Then run your web application, and only the first line of content shows up.