develog

MySql CharSet 관련 본문

DB/MySQL

MySql CharSet 관련

냐옴 2014. 4. 5. 15:04 
SHOW CHARACTER SET;
SHOW CHARACTER SET LIKE '%euc%';
SHOW CHARACTER SET LIKE '%utf%';
SHOW CHARACTER SET WHERE CHARSET LIKE '%euc%' OR CHARSET LIKE '%utf%';

SHOW COLLATION;
SHOW COLLATION LIKE '%euc%';
SHOW COLLATION LIKE '%utf%';
SHOW COLLATION WHERE CHARSET LIKE '%euc%' OR CHARSET LIKE '%utf%';


저작자표시

'DB > MySQL' 카테고리의 다른 글

[MySql] SQLException, Column 'COL_NM' not found  (0) 2014.04.05
MySql, SQL Error (1267): Illegal mix of collations  (0) 2014.04.05
iBatis, MySQL insert 후 insert Id 가져오기  (0) 2013.12.13
[MySql] Transaction Test  (0) 2013.12.12
[MySql] CREATE TABLE ENGINE  (0) 2013.12.12
'DB/MySQL' Related Articles more
Comments