File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSP and the fly likes Spaces are getting converted to  characters. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Spaces are getting converted to  characters." Watch "Spaces are getting converted to  characters." New topic

Spaces are getting converted to  characters.

Shifali Rana

Joined: Jul 08, 2010
Posts: 11

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
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 13027
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.


I agree. Here's the link:
subject: Spaces are getting converted to  characters.
It's not a secret anymore!