Spaces are getting converted to  characters.

[Shifali Rana]

Hello,

Whenever I am trying to save the words that are copied from MS Word to jsp text box in the database(MySQL) the spaces are getting converted to  characters.

I am using the following line in the jsp page may be it is converting the spaces to these characters.

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

Is the charset UTF-8 is need to be set for the Table column.

Why the spaces are getting converted to  characters when they saved in the database? Please help.


Thank You

[William Brogden]

What you see in WORD as a space is not really an ASCII space - the characters are not being converted, Word is supplying them.

Microsoft WORD does all sorts of tricks with punctuation and other character - for example "smart punctuation." This creates a ghastly problem for programmers.

It is possible to force Word to save as text with conversion to a regular character set.

Using a programmer's editor that can display the hex values of characters you can figure out what Word is actually writing and how to change the characters to normal ASCII or UNICODE.

Bill