you have to implement this specific "collation" e.g. by defining table
like
CREATE TABLE NOTES(
POSITION tinyint NOT NULL PRIMARY KEY,
CODE varchar(5) not null
)
INSERT INTO NOTES (POSITION,CODE)
VALUES(1,'C1')
INSERT INTO NOTES (POSITION,CODE)
VALUES(2,'C#1')
--....
INSERT INTO NOTES (POSITION,CODE)
VALUES(12,'B1') --i'm not sure if B1 is 12th semitone
INSERT INTO NOTES (POSITION,CODE)
VALUES(13,'C2')
--....