Dear MySQL fans,
I tested CONCAT() with binary strings and I got strange result.
Manual says:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
If the arguments include any binary strings, the result is a binary
string.
But the following test says:
bianry + latin1 ----> latin1 (not bianry)
mysql> SELECT CHARSET(CONCAT(_binary'Bianry',CONVERT('abc' USING latin1)));
+--------------------------------------------------------------+
| CHARSET(CONCAT(_binary'Bianry',CONVERT('abc' USING latin1))) |
+--------------------------------------------------------------+
| latin1 |
+--------------------------------------------------------------+
1 row in set (0.00 sec)
------------------------------------------------------------
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/
------------------------------------------------------------
My SUDOKU Probs http://www.pro.or.jp/~fuji/sudoku/problems/
------------------------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
