Hi there,
I tried a few other queries:
first, confirm that what you think is a binary is indeed a binary:
mysql> SELECT CHARSET(_binary'Binary');
+--------------------------+
| CHARSET(_binary'Binary') |
+--------------------------+
| binary |
+--------------------------+
1 row in set (0.00 sec)
check the regular text (for completeness' sake)
mysql> select charset ('binary');
+--------------------+
| charset ('binary') |
+--------------------+
| latin1 |
+--------------------+
1 row in set (0.00 sec)
OK, so concatenating the 2 should result in a binary according to the manual:
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)
Hrm, I got the same result you did.
However,
mysql> SELECT CHARSET(CONCAT(_binary'Binary','foo'));
+------------------------------------------+
| CHARSET(CONCAT((_binary'Binary'),'foo')) |
+------------------------------------------+
| binary |
+------------------------------------------+
1 row in set (0.00 sec)
works just fine. Why are you converting the text to latin1? It's
already there. That conversion seems to be messing things up.
Perhaps someone can explain why the conversion messes things up --
seems like a bug to me.
-Sheeri
On 2/26/06, Hirofumi Fujiwara <[EMAIL PROTECTED]> wrote:
> 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]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
