"." in query string messing up

I was working with queries that the data is being used for the meta description.

UPDATE cards SET meta_description = 'Amy\'s bugs address labels are printed on recycled label paper. Available in quantities of 30. Each label is 2.5 x 1 inch with rounded corners.' WHERE card_id = 'al007'

I have noticed though that the period after paper is shortening the meta description to just "Amy's bugs address labels are开发者_开发知识库 printed on recycled label paper." If I remove the period the entire description will show up then. Does anyone know how to solve this tiny dilemma?

I'm pretty sure that the issue is in whatever place you see the results. Most likely, there's a line feed after the period and your device does not support/show multi-line data. When you remove the period, you probably remove the carriage return as well.

Try escaping the period with '\'

Since you say, by removing period, the whole sentence is getting updated, I assume there is no problem with the column size.