Notice
Recent Posts
Recent Comments
Link
| ์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
|---|---|---|---|---|---|---|
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |
| 31 |
Tags
- Update
- ๋ฐฐ์ด
- DATE_FORMAT
- JSP
- JavaScript
- ๋์ปค
- ํ๋ก๊ทธ๋๋จธ์ค
- JS
- ๋ฐฑํฑ
- ํ ์ด๋ธ
- ์ธ๋ผ์ธ๋ทฐ
- oracle
- ํจ์
- post๋ฐฉ์
- ๋ฆฌ๋ ์ค
- Spring
- ์๋ฐ์คํฌ๋ฆฝํธ
- SQL
- ๋ณ์
- select
- MySQL
- ์ฝํ
- order by
- like
- ๋ช ๋ น์ด
- ๋์
- Ajax
- ์ปจํธ๋กค๋ฌ
- optionํ๊ทธ
- ๋์ ํ ์ด๋ธ
Archives
- Today
- Total
bom's happy life
[MYSQL] collation ํ์ธ, ์ถฉ๋์๋ฌ ๋ณธ๋ฌธ
Deveolpment Study๐๏ธ/Databases
[MYSQL] collation ํ์ธ, ์ถฉ๋์๋ฌ
bompeach 2023. 9. 22. 14:15https://velog.io/@mooh2jj/MySQL-Character-Set-Collation-%ED%99%95%EC%9D%B8
[MySQL] Character Set, Collation ํ์ธ
๋ฌธ์์ (Character set) ๊ณผ ์ฝ๋ ์ด์ (Collation) CHAR, VARCHAR, TEXT ๋ฑ์ ๋ฌธ์์ด Datatype์๋ ๋ฌธ์์ (Character set)๊ณผ ์ฝ๋ ์ด์ (Collation) ์์ฑ์ด ์๋ค. ๋ฌธ์์ (Character set)์ ๊ฐ ๋ฌธ์๊ฐ ์ปดํจ
velog.io
https://bstar36.tistory.com/318
COLLATION ๋ณ๊ฒฝ/์ค๋ฅ์ฝ๋: 1267
๊ฐ๋ฐ / ์ด์ ์ชฝ ํ ์ด๋ธ์ collation์ด ๋ง์ง ์์์ ์ฟผ๋ฆฌ ์ํ ์์ ๋ค์๊ณผ ๊ฐ์ ์๋ฌ๊ฐ ๋ฐ์ ํจ. ์ฟผ๋ฆฌ: SELECT cash, in_cash FROM tb_cash where svc_inst_no = @tid and cash_attr_no = @cashAttrNo LIMIT 0, 1000 ์ค๋ฅ ์ฝ๋: 1267Il
bstar36.tistory.com
'Deveolpment Study๐๏ธ > Databases' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
| [MYSQL] LIKE ํน์ ๋ฌธ์์ด ๊ฒ์ (0) | 2023.09.22 |
|---|---|
| [MYSQL] CONCAT, CONCAT_WS ํจ์, ์ฌ์ฉ๋ฒ (0) | 2023.09.22 |
| [SQL] WHERE 1=1๋? ์ฌ์ฉํ๋ ์ด์ ? (0) | 2023.09.13 |
| [MYSQL] CASE WHEN THEN ๊ตฌ๋ฌธ (0) | 2023.09.12 |
| [MYSQL] LIKE๋ฅผ ๊ฐ๋จํ๊ฒ ์ ๊ท์์ผ๋ก ๋ฐ๊พธ๊ธฐ (0) | 2023.09.12 |