• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Spaces are getting converted to  characters.

 
Shifali Rana
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Author and all-around good cowpoke
Rancher
Posts: 13058
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic