Quote:
Originally Posted by Murali  Hi Priyan,
Found a new one, check this out.
In MYSQL
mysql> SELECT myfield FROM test_cast;
SELECT CAST(GROUP_CONCAT(myfield)AS BINARY) FROM test_cast;
In ORACLE
SELECT CAST('123'AS INTEGER) AS VAL FROM DUAL;
SELECT CAST('123,ABCD'AS INTEGER) AS VAL FROM DUAL;
Seems to be CAST Functionality differs with using GROUP_CONCAT() Function in MYSQL. |
When i use
Code:
mysql> SELECT GROUP_CONCAT(CAST(MyTable_Id AS BINARY)),GROUP_CONCAT(CAST(MyTable_Value AS BINARY)) FROM MyTable;
This returns the recordset but with warnings !!!!! Code:
mysql> show warnings;
+---------+------+--------------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------+
| Warning | 1260 | 1 line(s) were cut by GROUP_CONCAT() |
+---------+------+--------------------------------------+
1 row in set (0.00 sec)
Could i know is that any limitations for GROUP_CONCAT() and how to overcome it?