Skip to main content
Known Participant
June 13, 2009
Answered

adding 3 dots in a database causes a square to appear instead

  • June 13, 2009
  • 1 reply
  • 455 views

When ever I insert 3 dots in my database like this "..." with out the quotes and insert the row into my php site a square appears instead of those 3 dots and in firefox the square also has fffd written in it. What can I do to avoid this.

This topic has been closed for replies.
Correct answer David_Powers

It's an encoding issue. It sounds as though you might be pasting from a Word document. Word converts three dots to an ellipsis. I don't know which encoding Word uses, but if it doesn't match the encoding of your application and database, it will display incorrectly. You need to ensure that Word (or whatever you're using to create the text) doesn't convert three dots to an ellipsis, but preserves the original three dots.

1 reply

David_Powers
David_PowersCorrect answer
Inspiring
June 13, 2009

It's an encoding issue. It sounds as though you might be pasting from a Word document. Word converts three dots to an ellipsis. I don't know which encoding Word uses, but if it doesn't match the encoding of your application and database, it will display incorrectly. You need to ensure that Word (or whatever you're using to create the text) doesn't convert three dots to an ellipsis, but preserves the original three dots.

adi3199Author
Known Participant
June 13, 2009

Thanks a lot man u have helped me a lot and I really appreciate it.

Keep up the great work.