Regarding carriage returns showing up - this is simple : Look at any HTML page source.

You will see it is littered with many carriage returns, long areas with many spaces and so on. In HTML, the spaces (more than one) are condensed into one space, and carriage returns are not significant sas they would be in a standard .txt file.

So, you need to convert the /r/n into HTML line breaks, <br />
Luckily, PHP has a function to do this ;-)

Assume your database content is stored in a variable $result, then use

This will output <br /> where the newlines are within your content.

About character encoding

(1) Input encoding : You need to specify the encoding of your HTML document initially, I suggest using
a meta tag like this :
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

Then (2) , you need to tell your server that the content being posted is in a certain range of characters. You can do this using the FORM element's accept-charset tag. This list can be multiple charsets, and is comma or space separated

form accept charset="utf-8"

So you might want to read up on this

(3) There is some information on russian forms handling here :

(4) MySQL has character set support which varies by version. MySQL 4 has the best native support, other versions may need some character set support to be compiled into the binary. I believe UTF-8 is supported by default, which is usually OK in the european / americas regions.

You need to speak to your ISP or techies about this. Some functions may be affected by the chosen character sets (eg FULLTEXT searches and so on). See more here :

Cheers - Neil Smith.

At 14:03 20/01/2004 +0000, you wrote:
Date: Tue, 20 Jan 2004 14:59:32 +0100
From: Christine Clerc <[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii" ; format="flowed"
Subject: Different character sets


My pages collect short texts from different languages through HTML forms. The texts are stored in a MySQL database. Then, they are used in HTML pages.

Problem 1 : the carriage returns don't show back up.
Problem 2 : The character above chr128 are not coded properly (obviously)
Problem 3 : what about other character sets (russian for example)

Thank you for any information on those subjects.


CaptionKit : Production tools
for accessible subtitled internet media, transcripts
and searchable video. Supports Real Player, Quicktime
and Windows Media Player.

VideoChat with friends online, get Freshly Toasted every
day at : NetMeeting solutions
for a connected world.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to