all white spaces have been deleted

[Migrated From Jforum.net]

all white spaces have been deleted.
this caused by database.
all white spaces should be replaced by & n b s p ; before post is inserted into database
[originally posted on jforum.net by jonahliu]

[Migrated From Jforum.net]

No, they don't. Replace spaces by the "non blank space" html char is not an option at all.

Which database are you using? it not common to get this behaviour.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

I use mysql 4.0.x how to resolve this problem?config database properties?
[originally posted on jforum.net by jonahliu]

[Migrated From Jforum.net]

As showed above,I typed some spaces between x and how when I replyed.But we could see only one space.
[originally posted on jforum.net by jonahliu]

[Migrated From Jforum.net]

Ok, but this is a limitation from HTML. The database keeps all blank spaces you have written. Only when you see it as HTML the extra ones will be interpreted as being only one.

If you want to have your blank spaces preserved, you have two choices:

1) put the contents inside a [code] tag
2) Write the by hand while writting the message.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Rafael Steil wrote:Ok, but this is a limitation from HTML. The database keeps all blank spaces you have written. Only when you see it as HTML the extra ones will be interpreted as being only one.
Rafael

Yeah,I was wrong.Thanks for your correct.

Rafael Steil wrote:
If you want to have your blank spaces preserved, you have two choices:


2) Write the by hand while writting the message.

sorry,I could not understand.would you like express it in another words?


[originally posted on jforum.net by jonahliu]

[Migrated From Jforum.net]

oooopsss.. some words were missing in my previous message

I meant: you could write the   thing in the message if you want extra-spaces.

Rafael
[originally posted on jforum.net by Rafael Steil]