(2 rows)
select *,character_length(ÍѸì) from ·×»»µ¡ÍѸì;
- ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è | length
-----------------------------+------------+------------+--------
- ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | | 12
- ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | | 13
- ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | | 12
+ ÍѸì | ʬÎॳ¡¼¥É | È÷¹Í1a¤À¤è | char_length
+----------------------------+------------+------------+-------------
+ ¥³¥ó¥Ô¥å¡¼¥¿¥Ç¥£¥¹¥×¥ì¥¤ | µ¡A01¾å | | 12
+ ¥³¥ó¥Ô¥å¡¼¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹ | ʬB10Ãæ | | 13
+ ¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥Þ¡¼ | ¿ÍZ01²¼ | | 12
(3 rows)
select *,octet_length(ÍѸì) from ·×»»µ¡ÍѸì;