SQL> select * from test_1;

NFZ                     NMSG
———————– ——————————————————————————–
512221197602044091     
522123197512230017     
512221197602044091     

SQL> update test_1 set nmsg=’代理名121′;

3 rows updated

SQL> commit;

Commit complete

SQL> select asciistr(nfz) a, asciistr(nmsg) b from test_1;

A                                                                                B
——————————————————————————– ——————————————————————————–
512221197602044091                                                               \4EE3\7406\540D121
522123197512230017                                                               \4EE3\7406\540D121
512221197602044091                                                               \4EE3\7406\540D121

SQL> select instr(asciistr(nmsg),’\')  from test_1;

INSTR(ASCIISTR(NMSG),’\')
————————-
                        1
                        1
                        1

SQL>


评论

该日志第一篇评论

发表评论

评论也有版权!