
Untitled
By: a guest on
May 9th, 2012 | syntax:
None | size: 0.52 KB | hits: 26 | expires: Never
MySQL 5.1 - Converting Blob to Text
CREATE TABLE `sessionparameter` (
`sessionId` INT(11) NOT NULL,
`serialValue` TINYBLOB NOT NULL,
`name` VARCHAR(255) NOT NULL COLLATE 'utf8_unicode_ci',
PRIMARY KEY (`sessionId`, `name`),
INDEX `fk_sessionparameter_session` (`sessionId`),
CONSTRAINT `fk_sessionparameter_session` FOREIGN KEY (`sessionId`) REFERENCES `session` (`id`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB
ROW_FORMAT=DEFAULT
SELECT CONVERT(serialValue USING utf8) FROM sessionparameter;