I use the following code to generate a uuid concat with CMRC
it works fine uuid is generated in lower case i.e. CMRC+someString in lower case

I could not find anything to resolve this i had to post this on here for help
how can I convert this generated uuid to caps or uppercase within trigger in mysql before insert?

BEGIN
INSERT INTO clients_seq VALUES (NULL);
SET NEW.cid = CONCAT('CMRC', LPAD(UUID(), 10, '0'));
END

Recommended Answers

All 2 Replies

Thanks cereal your solution works fine.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.