위치 : 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..

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..

jdbc:mysql://localhost:3306/EMS51?characterEncoding=euckr

* euckr에서 uft8로 변경 방법 mysql>SET character_set_client = utf8; mysql>SET character_set_results = utf8; mysql>SET character_set_connection = utf8; mysql>ALTER DATABASE ems50 DEFAULT CHARACTER SET utf8; commit; 반대로 * uft8에서 euckr로 변경 방법 SET character_set_client = euckr; SET character_set_results = euckr; SET character_set_connection = euckr; ALTER DATABASE EMS51 DEFAULT CHARACTER SET euckr; commit; ..

SQLPLUS> sqlplus /nolog SQLPLUS> conn /as sysdba SQLPLUS> SHUTDOWN IMMEDIATE; SQLPLUS> STARTUP MOUNT; SQLPLUS> ALTER SYSTEM ENABLE RESTRICTED SESSION; SQLPLUS> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQLPLUS> ALTER DATABASE OPEN; SQLPLUS> ALTER DATABASE CHARACTER SET KO16KSC5601; SQLPLUS> ALTER DATABASE NATIONAL CHARACTER SET KO16KSC5601; SQLPLUS> update props$ set value$='KO16KSC5601' where nam..