Re: incorrect char() string for bigint column

[Barry Galbraith]

Is this what you mean?

mysql> SELECT BI
    -> , CAST(BI AS CHAR)
    -> FROM
    -> TESTBICHAR;
+--------------+------------------+
| BI           | CAST(BI AS CHAR) |
+--------------+------------------+
| 130333868145 | 130333868145     |
+--------------+------------------+
1 row in set (0.00 sec)

Or what are really trying to do?

Good luck,
Barry.



Edited 1 time(s). Last edit at 08/07/2011 07:40PM by Barry Galbraith.