Here are charcodes of full-width space (IDSP,Ideographic Space) of sjis, ujis and utf8:
sjis 81 40 ujis A1 A1 utf8 E3 80 80 String processing functions TRIM, LTRIM, and RTRIM don't recognize full-width space in a string. They don't trim the full-width space and leave it in string. It seems that the functions don't process Japanese full-width space as space. ------------------------------------------------------------ Hirofumi Fujiwara (Tokyo JAPAN) enjoy JAVA and Puzzle World [EMAIL PROTECTED] http://www.pro.or.jp/~fuji/index-eng.html [EMAIL PROTECTED] Puzzle Japan http://www.puzzle.jp/ ------------------------------------------------------------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
