Q&A
- Mysql/Oracle/Query/DB Áú¹®°ú´äº¯
utfȯ°æÀε¥ ¤¾À¸·Î ½ÃÀÛÇÏ´Â ¸ðµçÀÚ·á°¡ °Ë»öÀÌ ¾ÈµÅ¿ä... | |||||
±Û¾´ÀÌ | Ãʳ⺴ | ³¯ Â¥ | 09-03-22 15:12 | Á¶ ȸ | 3061 |
---|---|---|---|---|---|
°£ÆíURL |
https://www.phpschool.com/link/qna_db/147395
|
||||
'¤¡'À» Ŭ¸¯Çϸé '¤¡'À¸·Î ½ÃÀÛÇÏ´Â ¸ðµç À̸§À» '¤¤'À» Ŭ¸¯Çϸé '¤¤'À¸·Î ½ÃÀÛÇÏ´Â ¸ðµç À̸§Àº ºÒ·¯¿À´Âµ¥(¤¡~¤½±îÁö´Â ºÒ·¯¿È)
'¤¾'À» Ŭ¸¯Çϸé '¤¾'À¸·Î ½ÃÀÛÇÏ´Â ÀÚ·á´Â ºÒ·¯¿ÀÁö ¸øÇÕ´Ï´Ù. Äõ¸®¸¦ ¾îÂî ½á¾ßÇÒÁö... ±×Àú ¸·¸·ÇÕ´Ï´Ù. $utf1 = iconv("EUCKR","UTF-8","°¡"); $utf2 = iconv("EUCKR","UTF-8","³ª"); $query = "SELECT * FROM table WHERE name between binary('".$utf1; $query .= "') and binary('".$utf2."')"; ÀÌÇÏ°í Çϸé '¤¡'¿¡¼ '¤½'±îÁö´Â ÀÚ·á°¡ °Ë»öÀÌ µÇ´Âµ¥ '¤¾'À¸·Î ½ÃÀÛÇÏ´Â ÀÚ·á°¡ °Ë»öÀÌ ¾ÈµË´Ï´Ù. $utf1 = iconv("EUCKR","UTF-8","ÇÏ"); $utf2 = iconv("EUCKR","UTF-8","힣"); $query = "SELECT * FROM table WHERE name between binary('".$utf1; $query .= "') and binary('".$utf2."')"; À̶ó°í ÇÏ´Ï±î °Ë»öÀÌ ¾ÈµÇ³×¿ä. $utf2 = iconv("EUCKR","UTF-8",chr(0xFE)); À¸·Î ÇÏ¿©µµ °Ë»öÀÌ ¾ÈµË´Ï´Ù. Âü°í·Î mysql Àº utf-8·Î ÀúÀåµÇ¾ú½À´Ï´Ù. myslq ¹öÁ¯ : 5.0.67À̱¸¿ä, PHP¹öÁ¯Àº 5.2.8ÀÔ´Ï´Ù window XP¿¡¼ »ç¿ëÇÏ°í ÀÖ½À´Ï´Ù. °í¼ö´Ôµé ¸¹Àº ºÎŹµå¸³´Ï´Ù~~
|
1 2 3 4