When using DB2 databases, it is inevitable to insert special characters into table fields. This article will show you how to insert special characters into DB2 database tables for your reference, hope to help you,
1. Insert the character @ # (single reference)
Insert into DB2ADMIN. aaaa values (@#@#@#@#);
Insert into DB2ADMIN. aaaa values (# A ######## B @#);
2. Insert characters ~
Insert into DB2ADMIN. aaaa values (@#~ @#);
Insert into DB2ADMIN. aaaa values (@ # ~ B @#);
3. Insert characters!
Insert into DB2ADMIN. aaaa values (@#! @#);
Insert into DB2ADMIN. aaaa values (@ #! B @#);
4. Insert characters @
Insert into DB2ADMIN. aaaa values (@#@@#);
Insert into DB2ADMIN. aaaa values (@ # A @ B @#);
5. Insert characters #
Insert into DB2ADMIN. aaaa values (@##@#);
Insert into DB2ADMIN. aaaa values (@ # A # B @#);
6. Insert characters $
Insert into DB2ADMIN. aaaa values (##$ @#);
Insert into DB2ADMIN. aaaa values (@ # A $ B @#);
7. Insert characters %
Insert into DB2ADMIN. aaaa values (% @#);
Insert into DB2ADMIN. aaaa values (@ # A % B @#);
8. Insert character ^
Insert into DB2ADMIN. aaaa values (##^ @#);
Insert into DB2ADMIN. aaaa values (@ # A ^ B @#);
9. Insert characters &
Insert into DB2ADMIN. aaaa values (@#&@#);
Insert into DB2ADMIN. aaaa values (@ # A & B @#);