Hi,
I know about CONVERT but I wanted to check character set of 'tt' column
and this result use in CONVERT. Something like CONVERT(id USING
CHARSET(Name))
which doesn't work.
It wont. the syntax is -- CONVERT(expr USING transcoding_name); its the
name of the transcode and not an expr.
I just wonder why CONCAT(1, ',', Name) works OK even if CHARSET(1) is
binary string and CONCAT(id, ',', Name) doesn't
It does.
mysql> select concat(1,',',tt) from test;
+------------------+
| concat(1,',',tt) |
+------------------+
| 1,a |
| 1,b |
| 1,c |
+------------------+
3 rows in set (0.00 sec)
mysql> select concat(id,',',tt) from test;
+-------------------+
| concat(id,',',tt) |
+-------------------+
| 1,a |
| 2,b |
| 3,c |
+-------------------+
3 rows in set (0.00 sec)
Thanks
ViSole DB Team.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
