When I use multi-byte code (especially UTF-8) with data including Kanji (Japanese kanji character) and execute SELECT from mysql client command, the vertical lines(|) of output table aren't aligned as straight lines and the output doesn't look like a table.
When I use SJIS code, the problem of sheared line doesn't occur. This is because the display width and the byte number of data always match. To display multi-byte code, not only the count of character and byte, but the display width is also very important. The width of Kanji in EUC-JP, SJIS, and UTF-8 is double the width of alphanumeric characters. As far as I could see, the result of functions involving display, such as LPAD and RPAD, doesn't seem to take the display width of Kanji into account. ------------------------------------------------------------ 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]
