PDA

View Full Version : text gets cut off


souperman
11-08-2011, 05:58 PM
My board is having issues with member's post, signatures, PMs, etc. Their text gets cut off when the following characters is foreign or non-US standard character. Like ó or even the ` apostrophe. At first I thought it was magic quotes, but I disabled it via php.ini, but the problem is still there.

So to reiterate the problem, when a user enters text in a box some of the text/post gets get cut off if the following character is foreign. For example "My name is Sam, Helló what's your name?"

In that sentence, only "My name is Sam, Hell" will be posted and will ignore everything to the right of ó

Hope that make sense. Any thoughts on this?

snakes1100
11-08-2011, 08:44 PM
What character collation is sql & the db using?

souperman
11-09-2011, 01:04 AM
MySQL uses utf8_unicode_ci

snakes1100
11-09-2011, 02:58 PM
What are the rest of the char variables for sql?

What are the char's used in the corresponding db table?

souperman
11-09-2011, 05:27 PM
It uses the same, utf8_unicode_ci