I'm having trouble sending accented texts to the database as words with Ç Ã etc.
Let's say I send text like this This is a post action for you
What happens and only sends ata That and a the rest of the text is not being sent this giving error of coding the texts. How can I fix this?
CREATE TABLE IF NOT EXISTS 'news' (
'id' int(255) NOT NULL AUTO_INCREMENT,
'titulo_url' varchar(255) COLLATE utf8_unicode_ci NOT NULL,
'titulo' varchar(255) COLLATE utf8_unicode_ci NOT NULL,
'noticia' text COLLATE utf8_unicode_ci NOT NULL,
'data' date NOT NULL,
'hora' time NOT NULL,,
'avatar' varchar(100) COLLATE utf8_unicode_ci NOT NULL,
'autor' char(20) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY ('id'),
UNIQUE KEY 'tituloUnico' ('titulo'),
UNIQUE KEY 'urlUnica' ('titulo_url'),
KEY 'colunasIndexadas' ('id','titulo_url','autor')
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
I do not know why you're giving this error in the submission form.