[DBMS] DB Incorrect String Value 에러
Incorrect String Value 에러 원인 DB의 인코딩이 어딘가 맞지않아 생기는 전형적인 문제이다. 해결 my.ini 파일을 찾아서 아래와 같이 넣어주기 [mysqld] datadir=C:/Program Files/MariaDB 10.4/data port=3306 innodb_buffer_pool_size=2039M character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci [client] port=3306 plugin-dir=C:/Program Files/MariaDB 10.4/lib/plugin default-character-set = utf8mb4 [my..
[스프링/JDBC] The server time zone value is unrecongnized or represents more than one time zone 에러
The server time zone value is unrecongnized or represents more than one time zone 아래 문장처럼 The server time zone value 경고문이 나올 때 해결방법 ###Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value '' is unreconized or represents mo..