SQL 对特殊字符的处理

字符：'
请看一下语句有什么问题：
insert into sonedba.arcmessage values((SELECT COALESCE(MAX(arcmessageKy), 0) + 1 FROM sonedba.ARCmessage),(SELECT ARCLocaleCdKy FROM sonedba.ARCLocaleCd WHERE name = 'th'),null,'KBPNcnclrsn03','03- [color=red]Customer' signature[/color] differs from speciment given to bank','CRM',char(CURRENT TIMESTAMP),'system','KBN',1);