uppercase words in input box does not match

Question

Recently I did text-transform: capitalize in css where the first letter of each word is capitalized but the data in phpmyadmin is in lowercase. It will only be uppercase if I manually capitalize the letter. How can I fix it?

Answer 1

You can create a triggers on insert and update

CREATE TABLE Test(id INTEGER, title VARCHAR(255));    
DELIMITER $$
CREATE 
    TRIGGER ucwordOnTestInsert
    BEFORE insert
    ON Test
    FOR EACH ROW
    BEGIN
        SET NEW.title = initcap(NEW.title);
    END$$
CREATE 
    TRIGGER ucwordOnTestUpdate
    BEFORE update
    ON Test
    FOR EACH ROW
    BEGIN
        SET NEW.title = initcap(NEW.title);
    END$$
CREATE
    FUNCTION `initcap`(input VARCHAR(255))
    RETURNS VARCHAR(255)    
    BEGIN
    DECLARE len INT;
    DECLARE i INT;

    SET len   = CHAR_LENGTH(input);
    SET input = LOWER(input);
    SET i = 0;

    WHILE (i < len) DO
            IF (MID(input,i,1) = ' ' OR i = 0) THEN
                    IF (i < len) THEN
                            SET input = CONCAT(
                                    LEFT(input,i),
                                    UPPER(MID(input,i + 1,1)),
                                    RIGHT(input,len - i - 1)
                            );
                    END IF;
            END IF;
            SET i = i + 1;
    END WHILE;

    RETURN input;
    END$$

DELIMITER ;

insert into Test(id, title) values(1, "hello");
insert into Test(id, title) values(2, "hello world");
insert into Test(id, title) values(3, "hello World");
insert into Test(id, title) values(4, "hello World");
UPDATE `Test` SET title = 'this is a big test' WHERE `id` = 4;   
SELECT * FROM Test;

You can see it working demo here

If you need to update your old data just update all rows:

UPDATE `Test` SET title= title

You can read more for function initcap