oracle ¹ØÓÚĩβ´øbºÍ²»´øbµÄº¯Êý½á¹û±È½Ï
Ñ¡Ôñº¯ÊýsubstrºÍsubstrb±È½Ï
²î±ðÔÚÓÚsubstr°´ÕÕ×Ö·û£¨char£©À´±È½Ï£¬substrb°´ÕÕ±ÈÌØÎ»£¨byte£©À´±È½Ï¡£
?
select substr£¨'¤¢¤ê¤Þ¤»¤ó', 1, 5£© from dual;
?
SUBSTR£¨'¤¢¤ê¤Þ¤»¤ó',1,5£©
------------------------------
¤¢¤ê¤Þ¤»¤ó
?
?
select substrb('¤¢¤ê¤Þ¤»¤ó', 1, 5) from dual;
?
SUBSTRB('
----------
¤¢
?
select substrb('¤¢¤ê¤Þ¤»¤ó', 1, 6) from dual;
SUBSTRB('¤¢
------------
¤¢¤ê
?
?
ÈÕÎÄ×Ö·ûÕ¼Èý¸öbyte£¬½ØÈ¡µÄʱºò£¬substrbÊÇ´ÓµÚһλ¿ªÊ¼½ØÈ¡6¸öbyteµÄ×Ö·û¡£
substrÊÇ´ÓµÚÒ»¸ö×Ö·û¿ªÊ¼½ØÈ¡6¸ö×Ö·û¡£