[MariaDB]언어셋 설정
·
Database
위치 : C:/Program Files/MariaDB 10.1/data/my.ini 백업 후 아래 추가 서비스 재시작 윈도우일경우 my.ini 리눅스일경우 /etc/my.cnf [mysqld] datadir=C:/Program Files/MariaDB 10.1/data port=3306 sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" default_storage_engine=innodb innodb_buffer_pool_size=445M innodb_log_file_size=50M #하단추가 init_connect="SET collation_connection = utf8_general_ci" init_connect="SET NAMES utf8" chara..
[DB] Charset 확인 test
·
Database
Connection con = null;ResultSet rs = null;Statement stmt = null;String url = "jdbc:mysql://localhost:3306/EMS51?useUnicode=true&characterEncoding=euckr";String usr = "usr";String pwd = "pwdString drv = "org.gjt.mm.mysql.Driver";String query1_pre = " UPDATE EBCD0030 SET CODE_NAME = '"; String query1_suf = "' WHERE CODE_TYPE = '00' AND CODE_CODE = ";String query2 = " SELECT CODE_NAME EBCD0030 WHER..
[MYSQL] Charset Encoding
·
카테고리 없음
jdbc:mysql://localhost:3306/EMS51?characterEncoding=euckr