nie este vcera som zvecsil dlzku na varchar(1516)
a pred odoslanim som si dal echo
UPDATE indexus SET dressSmsg=('toto je update ...cez 500 char...about-the-universe mixture') WHERE lang=0
pokial je tam menej ako 500 tak sa updatne
Kód:
--
-- Štruktúra tabuľky pre tabuľku `indexus`
--
CREATE TABLE IF NOT EXISTS `indexus` (
`lang` int(1) NOT NULL,
`indexSmsg` varchar(1516) COLLATE utf8_slovak_ci NOT NULL COMMENT 'short message(up right)',
`indexMsg` varchar(1516) COLLATE utf8_slovak_ci NOT NULL COMMENT 'message (upright popup)',
`bagsSmsg` varchar(1516) COLLATE utf8_slovak_ci NOT NULL,
`bagsMsg` varchar(1516) COLLATE utf8_slovak_ci NOT NULL,
`dressSmsg` varchar(1516) COLLATE utf8_slovak_ci NOT NULL,
`dressMsg` varchar(1516) COLLATE utf8_slovak_ci NOT NULL,
`otherSmsg` varchar(1516) COLLATE utf8_slovak_ci NOT NULL,
`otherMsg` varchar(1516) COLLATE utf8_slovak_ci NOT NULL,
`contactsSmsg` varchar(1516) COLLATE utf8_slovak_ci NOT NULL,
`contactsMsg` varchar(1516) COLLATE utf8_slovak_ci NOT NULL,
PRIMARY KEY (`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci COMMENT='table with index messages';