목록DB/MySQL (35)

develog

MySQL insert 시 한글 깨질 때 해결방법

connection url 뒤에 아래 문구 붙임=> ?useUnicode=true&characterEncoding=utf8 utf8 은 '-' 빼고 소문자로 ex) jdbc:mysql://127.0.0.1:3306/MY_DB_SCHEMA?useUnicode=true&characterEncoding=utf8
DB/MySQL 2013. 12. 12. 10:43
MySQL JDBC 한글 깨짐

http://acedon.egloos.com/1668830 http://toriworks.tistory.com/entry/Spring-25-iBATIS-MySQL-5x-Tomcat-6x-UTF-%EA%B8%B0%EB%B0%98%EC%9D%98-%ED%95%9C%EA%B8%80-%EC%B2%98%EB%A6%AC http://madvens.wordpress.com/2013/07/29/java-mysql-utf-8-character-problem/
DB/MySQL 2013. 12. 11. 21:38
MySQL 인코딩 확인

show variables like 'c%'
DB/MySQL 2013. 12. 11. 21:22
MySQL 버전 확인

SELECT version()
DB/MySQL 2013. 12. 11. 21:21
UPDATE DATE

'DATE_COLUMN' = DATE(STR_TO_DATE('20131202', '%Y%m%d'))
DB/MySQL 2013. 12. 3. 19:59
CAST

CAST('COLUMN_NAME' AS SIGNED) CAST('COLUMN_NAME' AS UNSIGNED)
DB/MySQL 2013. 12. 3. 19:49
Prev 1 2 3 4 5 6 Next