mariaDB AES_ENCRYPT, AES_DECRYPT 한글 깨짐 오류

Question

insert 시 쿼리 입니다. INSERT INTO union_users( user_id , union_id , union_num , account_cnt , account_amt , reg_dt , mod_dt , mod_id , approval_dt )VALUES( #{userId} , hex(aes_encrypt(#{unionId},'union_id')) , hex(aes_encrypt(#{unionNum},'union_num')) , hex(aes_encrypt(#{accountCnt},'account_cnt')) , hex(aes_encrypt(#{accountAmt},'account_amt')) , #{regDt} , #{modId} , #{modDt} , #{approvalDt} ) 이런식으로 암호화하여 db에 저장했고 select * from ( select a.user_id ,AES_DECRYPT(unhex(a.user_name), 'user_name') user_name ,AES_DECRYPT(unhex(a.user_phone), 'user_phone') user_phone ,AES_DECRYPT(unhex(a.user_tel), 'user_tel') user_tel ,AES_DECRYPT(unhex(a.user_zip), 'user_zip') user_zip ,AES_DECRYPT(unhex(a.user_doro), 'user_doro') user_doro ,AES_DECRYPT(unhex(a.user_jibun), 'user_jibun') user_jibun ,AES_DECRYPT(unhex(a.user_nation1), 'user_nation1') user_nation1 ,AES_DECRYPT(unhex(a.user_nation2), 'user_nation2') user_nation2 ,AES_DECRYPT(unhex(a.user_email), 'user_email') user_email ,AES_DECRYPT(unhex(a.user_bnk), 'user_bnk') user_bnk ,AES_DECRYPT(unhex(a.user_depr_nm), 'user_depr_nm') user_depr_nm ,AES_DECRYPT(unhex(a.user_Auth), 'user_Auth') user_Auth ,AES_DECRYPT(unhex(b.union_id), 'union_id') union_id ,b.union_num ,AES_DECRYPT(unhex(b.account_cnt), 'account_cnt') account_cnt ,AES_DECRYPT(unhex(b.account_amt), 'account_amt') account_amt ,b.union_status ,AES_DECRYPT(unhex(b.invest_name), 'invest_name') invest_name ,b.reg_dt from users a join union_users b where a.user_id &#61; b.user_id and a.use_yn &#61; 'Y' and a.user_id &#61; #{userId} ) d order by union_num desc이런식으로 복호화하여 불러오려는데 일단 jsp에서 user_name을 복호화 하여 불러오면 í©ì¸ì° 이런식으로 나와서 db에서 쿼리써서 불러보니 한글부분들이 저렇게 나옵니다..구글링해서 cast as char 이런식으로 써봤는데 select * from ( select a.user_id ,cast(AES_DECRYPT(unhex(a.user_name), 'user_name')as char) user_name ,cast(AES_DECRYPT(unhex(a.user_phone), 'user_phone')as char) user_phone ,cast(AES_DECRYPT(unhex(a.user_tel), 'user_tel')as char) user_tel ,cast(AES_DECRYPT(unhex(a.user_zip), 'user_zip')as char) user_zip ,cast(AES_DECRYPT(unhex(a.user_doro), 'user_doro')as char) user_doro ,cast(AES_DECRYPT(unhex(a.user_jibun), 'user_jibun')as char) user_jibun ,cast(AES_DECRYPT(unhex(a.user_nation1), 'user_nation1')as char) user_nation1 ,cast(AES_DECRYPT(unhex(a.user_nation2), 'user_nation2')as char) user_nation2 ,cast(AES_DECRYPT(unhex(a.user_email), 'user_email')as char) user_email ,cast(AES_DECRYPT(unhex(a.user_bnk), 'user_bnk')as char) user_bnk ,cast(AES_DECRYPT(unhex(a.user_depr_nm), 'user_depr_nm')as char) user_depr_nm ,cast(AES_DECRYPT(unhex(a.user_Auth), 'user_Auth')as char) user_Auth ,cast(AES_DECRYPT(unhex(b.union_id), 'union_id')as char) union_id ,b.union_num ,cast(AES_DECRYPT(unhex(b.account_cnt), 'account_cnt')as char) account_cnt ,cast(AES_DECRYPT(unhex(b.account_amt), 'account_amt')as char) account_amt ,b.union_status ,cast(AES_DECRYPT(unhex(b.invest_name), 'invest_name')as char) invest_name ,b.reg_dt from users a join union_users b where a.user_id &#61; b.user_id and a.use_yn &#61; 'Y' and a.user_id &#61; #{userId} ) d order by union_num desc이런방식으로 타입을 지정해줬는데도 똑같이 뜹니다.. 해결방법이 있을까요?

캐티 · Answer

c# - AES_DECRYPT() and AES_ENCRYPT() in MySQL with Polish characters - Stack Overflow이거 어떠나요

mariaDB AES_ENCRYPT, AES_DECRYPT 한글 깨짐 오류

1개의 답변

#srping 목록