์•”ํ˜ธํ™” ํ•จ์ˆ˜ยถ

์•”ํ˜ธํ™” ํ•จ์ˆ˜๋Š” VARCHAR ๋˜๋Š” BINARY ๊ฐ’์„ ์•”ํ˜ธํ™”ํ•˜๊ฑฐ๋‚˜ ์•”ํ˜ธ ํ•ด๋…ํ•ฉ๋‹ˆ๋‹ค.

ํ•จ์ˆ˜

์ฐธ๊ณ 

ENCRYPT

์•”ํ˜ธ ๊ตฌ๋ฌธ์„ ์‚ฌ์šฉํ•ด VARCHAR ๋˜๋Š” BINARY ๊ฐ’์„ ์•”ํ˜ธํ™”ํ•ฉ๋‹ˆ๋‹ค.

DECRYPT

์•”ํ˜ธ ๊ตฌ๋ฌธ์„ ์‚ฌ์šฉํ•ด VARCHAR ๋˜๋Š” BINARY ๊ฐ’์„ ์•”ํ˜ธ ํ•ด๋…ํ•ฉ๋‹ˆ๋‹ค.

TRY_DECRYPT

DECRYPT์˜ ์˜ค๋ฅ˜ ์ฒ˜๋ฆฌ ๋ฒ„์ „์ž…๋‹ˆ๋‹ค.

ENCRYPT_RAW

๋ฐ”์ด๋„ˆ๋ฆฌ ํ‚ค์™€ ์ดˆ๊ธฐํ™” ๋ฒกํ„ฐ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ BINARY ๊ฐ’์„ ์•”ํ˜ธํ™”ํ•ฉ๋‹ˆ๋‹ค.

DECRYPT_RAW

๋ฐ”์ด๋„ˆ๋ฆฌ ํ‚ค์™€ ์ดˆ๊ธฐํ™” ๋ฒกํ„ฐ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ BINARY ๊ฐ’์„ ์•”ํ˜ธ ํ•ด๋…ํ•ฉ๋‹ˆ๋‹ค.

TRY_DECRYPT_RAW

DECRYPT_RAW์˜ ์˜ค๋ฅ˜ ์ฒ˜๋ฆฌ ๋ฒ„์ „์ž…๋‹ˆ๋‹ค.