preserve formatting in mysql db

hi

how do i preserve the text formatting in mysql?
for example i use java to store some text file into
mysql using the command

ps.setString(1,somecontent);

and then i want to retrieve back the text file and
display it in a web page, with the formatting
preserved; cause i noticed when i did this all the
formatting are gone, which renders the text in a mess.

any help are greatly appreciated. thanks


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Antwort: preserve formatting in mysql db

Hi

In C I use mysql_real_escape_string() and mysql_real_query() to sto=
re a
executable in a blob column.
should work for formatted text to.

mit freundlichen Grüßen

Thomas Treffehn

Hans Brochier GmbH & Co KG

Abteilung S2 - Informationswesen
Marthastraße 16
90482 Nürnberg

Fon: +49 0911-9543-355
Fax: +49 0911-9543-383
www.brochier.de



|---------+--------------------------->
| | Cadbury |
| | | | hoo.com> |
| | |
| | 14.03.2005 16:01|
|---------+--------------------------->
>----------------------------------------------------------- ---------=
-----------------------------------------------------------|
| =
|
| An: win32@lists.mysql.com =
|
| Kopie: =
|
| Thema: preserve formatting in mysql db =
|
>----------------------------------------------------------- ---------=
-----------------------------------------------------------|




hi

how do i preserve the text formatting in mysql?
for example i use java to store some text file into
mysql using the command

ps.setString(1,somecontent);

and then i want to retrieve back the text file and
display it in a web page, with the formatting
preserved; cause i noticed when i did this all the
formatting are gone, which renders the text in a mess.

any help are greatly appreciated. thanks


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dtreffehn@brochi=
er.de

=



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org