如何在DB2的表中插入特殊的字符
在實際的使用中可能會遇到要在表的字段中插入特殊字符的問題,我在此簡單的總結一下,歡迎大家繼續﹐以便和大家共享﹐共同探討﹐共同近步﹗(以下主要以DB2 7.X為例)。1. 插入字符 ' (單引號 ) INSERT INTO DB2ADMIN.AAAA VALUES(''); INSERT INTO DB2ADMIN.AAAA VALUES('A''B');2. 插入字符 ~ INSERT INTO DB2ADMIN.AAAA VALUES('~'); INSERT INTO DB2ADMIN.AAAA VALUES('A~B');3. 插入字符 ! INSERT INTO DB2ADMIN.AAAA VALUES('!'); INSERT INTO DB2ADMIN.AAAA VALUES('A!B');4. 插入字符 @ INSERT INTO DB2ADMIN.AAAA VALUES('@'); INSERT INTO DB2ADMIN.AAAA VALUES('A@B');5. 插入字符 # INSERT INTO DB2ADMIN.AAAA VALUES('#'); INSERT INTO DB2ADMIN.AAAA VALUES('A#B');6. 插入字符 $ INSERT INTO DB2ADMIN.AAAA VALUES('$'); INSERT INTO DB2ADMIN.AAAA VALUES('A$B');7. 插入字符 % INSERT INTO DB2ADMIN.AAAA VALUES('%'); INSERT INTO DB2ADMIN.AAAA VALUES('A%B');8. 插入字符 ^ INSERT INTO DB2ADMIN.AAAA VALUES('^'); INSERT INTO DB2ADMIN.AAAA VALUES('A^B');9. 插入字符 & INSERT INTO DB2ADMIN.AAAA VALUES('&'); INSERT INTO DB2ADMIN.AAAA VALUES('A&B');10. 插入字符 * INSERT INTO DB2ADMIN.AAAA VALUES('*'); INSERT INTO DB2ADMIN.AAAA VALUES('A*B');11. 插入字符 ( INSERT INTO DB2ADMIN.AAAA VALUES('('); INSERT INTO DB2ADMIN.AAAA VALUES('A(B');12. 插入字符 ) INSERT INTO DB2ADMIN.AAAA VALUES(')'); INSERT INTO DB2ADMIN.AAAA VALUES('A)B');13. 插入字符 _ INSERT INTO DB2ADMIN.AAAA VALUES('_'); INSERT INTO DB2ADMIN.AAAA VALUES('A_B');14. 插入字符 - INSERT INTO DB2ADMIN.AAAA VALUES('-'); INSERT INTO DB2ADMIN.AAAA VALUES('A-B');15. 插入字符 + INSERT INTO DB2ADMIN.AAAA VALUES('+'); INSERT INTO DB2ADMIN.AAAA VALUES('A+B');16. 插入字符 = INSERT INTO DB2ADMIN.AAAA VALUES('='); INSERT INTO DB2ADMIN.AAAA VALUES('A=B');17. 插入字符 / INSERT INTO DB2ADMIN.AAAA VALUES('/'); INSERT INTO DB2ADMIN.AAAA VALUES('A/B');18. 插入字符 < INSERT INTO DB2ADMIN.AAAA VALUES('<'); INSERT INTO DB2ADMIN.AAAA VALUES('A<B');19. 插入字符 > INSERT INTO DB2ADMIN.AAAA VALUES('>'); INSERT INTO DB2ADMIN.AAAA VALUES('A>B');20. 插入字符 ? INSERT INTO DB2ADMIN.AAAA VALUES('?'); INSERT INTO DB2ADMIN.AAAA VALUES('A?B');21. 插入字符 : INSERT INTO DB2ADMIN.AAAA VALUES(':'); INSERT INTO DB2ADMIN.AAAA VALUES('A:B');22. 插入字符 ; INSERT INTO DB2ADMIN.AAAA VALUES(CHR(59)); INSERT INTO DB2ADMIN.AAAA VALUES(ACHR(59)B);23. 插入字符 ' INSERT INTO DB2ADMIN.AAAA VALUES(''); INSERT INTO DB2ADMIN.AAAA VALUES('A''B');24. 插入字符 ` INSERT INTO DB2ADMIN.AAAA VALUES('`'); INSERT INTO DB2ADMIN.AAAA VALUES('A`B');25. 插入字符 | INSERT INTO DB2ADMIN.AAAA VALUES('|'); INSERT INTO DB2ADMIN.AAAA VALUES('A|B');26. 插入字符 \ INSERT INTO DB2ADMIN.AAAA VALUES('\');
INSERT INTO DB2ADMIN.AAAA VALUES('A\B');
27. 插入字符 { INSERT INTO DB2ADMIN.AAAA VALUES('{'); INSERT INTO DB2ADMIN.AAAA VALUES('A{B');28. 插入字符 } INSERT INTO DB2ADMIN.AAAA VALUES('}'); INSERT INTO DB2ADMIN.AAAA VALUES('A}B');29. 插入字符 [ INSERT INTO DB2ADMIN.AAAA VALUES('['); INSERT INTO DB2ADMIN.AAAA VALUES('A[B');30. 插入字符 ] INSERT INTO DB2ADMIN.AAAA VALUES(']'); INSERT INTO DB2ADMIN.AAAA VALUES('A]B');
待續...
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18