|
Total related article : 8 |
|
µî·ÏÀÏ: | 2001-06-19 |
½Ã°£: | 23:07:30 |
Á¶È¸¼ö: | 5105 |
from: | 211.187.190.155 |
|
[Áú¹®] mysql ¿¡ blobÀº BINARY°Ë»ö? |
±Û¾´ÀÌ : Anonymous |
|
MYSQL¿¡¼ BLOBÇüÅÂÀÇ Ä÷³Àº ´ë¼Ò¹®ÀÚ¸¦ °¡·Á¼ °Ë»öÇÏ´Â BINARY °Ë»öÀÌ ¾ÈµÇ³ªº»µ¥¿ä...
ÀÌ ±â´ÉÀ» ¾µ¼ö ÀÖµµ·Ï ÇÏ·Á¸é ¾î¶² ¾Ë°í¸®Áò(?) Çü½ÄÀ» ÃëÇØ¾ß Çϳª¿ä?
¾Æ´Ï¸é ÇØ°á¹æ¾ÈÀ̶óµµ.... ¼³¸¶ ¸øÇÑ´Ù°í´Â ÇÒ¼ö ¾ø°ÚÁÒ?
|
|
   |
|
µî·ÏÀÏ: | 2001-06-20 |
½Ã°£: | 15:32:04 |
Á¶È¸¼ö: | 5696 |
from: | 211.33.8.94 |
|
[´äº¯] [Áú¹®] mysql ¿¡ blobÀº BINARY°Ë»ö? |
±Û¾´ÀÌ : vopos |
|
>MYSQL¿¡¼ BLOBÇüÅÂÀÇ Ä÷³Àº >´ë¼Ò¹®ÀÚ¸¦ °¡·Á¼ °Ë»öÇÏ´Â BINARY °Ë»öÀÌ ¾ÈµÇ³ªº»µ¥¿ä... > >ÀÌ ±â´ÉÀ» ¾µ¼ö ÀÖµµ·Ï ÇÏ·Á¸é ¾î¶² ¾Ë°í¸®Áò(?) Çü½ÄÀ» >ÃëÇØ¾ß Çϳª¿ä? > >¾Æ´Ï¸é ÇØ°á¹æ¾ÈÀ̶óµµ.... >¼³¸¶ ¸øÇÑ´Ù°í´Â ÇÒ¼ö ¾ø°ÚÁÒ?
¾È³çÇϼ¼¿ä, HappyCGI ÆÀÀÇ voposÀÔ´Ï´Ù.
¸Þ´º¾ó¿¡ ÀÇÇϸé BOLB ŸÀÔÀº ÀúÀå/ºñ±³ ÇÒ¶§ ´ë¼Ò¹®ÀÚ±¸ºÐ(case sensitive)ÇÑ´Ù °í µÇ¾îÀִµ¥ °Ë»öÇÒ ¶§´Â ±×·¸Áö ¾ÊÀº°¡º¸ÁÒ?
Á¦°¡ ¹æ±Ý Å×À̺íÀ» ¸¸µé¾î Å×½ºÆ®¸¦ ÇÏ´Ï BLOB Ä÷³¿¡¼ ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÀ» ÇÏ´Â µ¥¿ä? Á÷Á¢ Å×½ºÆ®Çغ¸½Ã±â ¹Ù¶ø´Ï´Ù.
´ÙÀ½ ¸Þ´º¾ó ÆäÀÌÁöµéµµ Âü°íÇϼ¼¿ä.
http://www.mysql.com/doc/B/L/BLOB.html http://www.mysql.com/doc/C/a/Case_sensitivity.html http://www.mysql.com/doc/S/t/String_comparison_functions.html
°¨»çÇÕ´Ï´Ù.
- vopos
P.S.> È®ÀεÇÁö ¾ÊÀº Åë°è¿¡ ÀÇÇϸé 90% ÀÌ»óÀÇ ¹®Á¦´Â ¸Þ´º¾ó·Î ÇØ°áÇÒ ¼ö ÀÖ´Ù °í ÇÕ´Ï´Ù. ¸Þ´º¾óÀ» »ç¶ûÇսôÙ. ^^
/---------------------------------------------------------------------------------------------------- ÀÚÁÖ¹¯´Â Áú¹® Æ÷·³°ú Æ÷·³°Ë»öÀ» ÀÌ¿ëÇϼż ºñ½ÁÇÑ Áú¹®ÀÇ ´äº¯ÀÌ ÀÖ´ÂÁö È®ÀÎÇÏ½Ã°í ±Û ¿Ã·ÁÁÖ½Ã±æ ºÎŹµå¸³´Ï´Ù. ----------------------------------------------------------------------------------------------------/
|
|
   |
|
µî·ÏÀÏ: | 2001-06-20 |
½Ã°£: | 20:36:11 |
Á¶È¸¼ö: | 5246 |
from: | 211.229.117.133 |
|
      [´äº¯] [´äº¯] [Áú¹®] mysql ¿¡ blobÀº BINARY°Ë»ö? |
±Û¾´ÀÌ : Anonymous |
|
¾î¶ó... ¿Ö Àú´Â ¾ÈµÇ´Â°ÅÁÒ? ´ÙÀ½Àº Å×À̺íÀÇ ÀÚ·áÁß ÇϳªÀÔ´Ï´Ù. form À̶ó´Â À̸§À¸·Î blobÇüÅ ÀúÀåµÇ¾îÀÖ½À´Ï´Ù.
| scanf | printf¿Í °°ÀÌ °¡Àå ¸¶´µ ¾²ÀÌ´Â ÇÔ¼öÁß ÇϳªÀÌ´Ù. ÀÌ ÇÔ¼öµéÀº stdio.h¿¡ Á¤ÀǵǾî ÀÖÀ¸¸ç Ç¥ÁØ ÀÔ·ÂÀ» ´ã´çÇÏ´Â ÇÔ¼öÀÌ´Ù.
°Ë»öÇÒ¶§... select * from search where form regexp binary 'P'; ³ª select * from search where form like binary '%P%';
¸¦ Çϸé Empty set ÀÌ Ãâ·ÂµÇ´Âµ¥¿ä--;
|
|
   |
|
µî·ÏÀÏ: | 2001-06-21 |
½Ã°£: | 16:01:04 |
Á¶È¸¼ö: | 5034 |
from: | 211.33.8.94 |
|
           [´äº¯] [´äº¯] [´äº¯] [Áú¹®] mysql ¿¡ blobÀº BINARY°Ë»ö? |
±Û¾´ÀÌ : vopos |
|
>¾î¶ó... >¿Ö Àú´Â ¾ÈµÇ´Â°ÅÁÒ? ´ÙÀ½Àº Å×À̺íÀÇ ÀÚ·áÁß ÇϳªÀÔ´Ï´Ù. >form À̶ó´Â À̸§À¸·Î blobÇüÅ ÀúÀåµÇ¾îÀÖ½À´Ï´Ù. > >| scanf
|
|
   |
|
µî·ÏÀÏ: | 2001-06-21 |
½Ã°£: | 20:17:25 |
Á¶È¸¼ö: | 5003 |
from: | 211.228.220.150 |
|
                [´äº¯] [´äº¯] [´äº¯] [´äº¯] [Áú¹®] mysql ¿¡ blobÀº BINARY°Ë |
±Û¾´ÀÌ : Anonymous |
|
±ÛÀ» À߸ø ÃƳ׿ä. binary ¸¦ »©°í ÇØ¾ß Çߴµ¥....
´ÙÀ½Àº mysql¿¡¼ ½ÇÇàÇÑ °ÍÀ» º¹»çÇؿ°̴ϴÙ.
mysql> select * from search where form like '%p%'; +-------+----------------------------------------------------------------------- ------------------------------------------------+ | name | form | +-------+----------------------------------------------------------------------- ------------------------------------------------+ | scanf | printf¿Í °°ÀÌ °¡Àå ¸¶´µ ¾²ÀÌ´Â ÇÔ¼öÁß ÇϳªÀÌ´Ù. ÀÌ ÇÔ¼öµéÀº stdio.h¿¡ Á¤ÀǵǾî ÀÖÀ¸¸ç Ç¥ÁØ ÀÔ·ÂÀ» ´ã´çÇÏ´Â ÇÔ¼öÀÌ´Ù. | | aaaa | pppppppppp | +-------+----------------------------------------------------------------------- ------------------------------------------------+ 2 rows in set (0.01 sec)
mysql> select * from search where form like '%PP%'; Empty set (0.00 sec)
mysql> select * from search where form like '%PP%'; Empty set (0.01 sec)
mysql>
ÀÌ·¸½À´Ï´Ù. form Àº blobÀ¸·Î ¼³Á¤µÇ¾î ÀÖ±¸¿ä.....
È®ÀÎÇØ º¸´Ï±î ¿©±â HAPPYCGI ¿¡¼µµ FORM.CGI ¶ó´Â °Ë»ö¾î¸¦ ÃÆÀ»¶§´Â °Ë»ö¹°ÀÌ ¾ø´Ù°í ³ª¿À´Âµ¥ form.cgiÄ¡¸é 4°³°¡ ³ª¿À³×¿ä... ¿©±âµµ ¾ÈµÇ´Â°Í °°Àºµ¥.....
|
|
   |
|
µî·ÏÀÏ: | 2001-06-22 |
½Ã°£: | 12:24:20 |
Á¶È¸¼ö: | 4950 |
from: | 211.33.8.94 |
|
                     [´äº¯] [´äº¯] [´äº¯] [´äº¯] [´äº¯] [Áú¹®] mysql ¿¡ blobÀº BI |
±Û¾´ÀÌ : vopos |
|
BLOB µ¥ÀÌŸŸÀÔÀº ºñ±³ÇÒ ¶§ ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇϴµ¥¿ä. ´ç¿¬È÷ form Ä÷³³»¿¡ ´ë¹®ÀÚ P°¡ ¾øÀ¸´Ï ãÁö¸¦ ¸øÇؼ °á°ú°ªÀÌ ¾ø´Â°ÅÁÒ.
¹º°¡ ¿ÀÇظ¦ ÇϽŵí...^^
- vopos
|
|
   |
|
µî·ÏÀÏ: | 2001-06-22 |
½Ã°£: | 20:23:20 |
Á¶È¸¼ö: | 4961 |
from: | 211.228.220.170 |
|
                          [´äº¯] [´äº¯] [´äº¯] [´äº¯] [´äº¯] [´äº¯] [Áú¹®] mysql ¿¡ bl |
±Û¾´ÀÌ : Anonymous |
|
Á¦°¡ ¿øÇß´ø°Ç blob Ä÷³ ³»¿¡¼µµ ´ë¼Ò¹®ÀÚ ±¸ºÐÀ» ÇÏÁö ¾Ê°í... ã±â¸¦ ¹Ù·¨´ø °Ì´Ï´Ù........ --;
|
|
   |
|
µî·ÏÀÏ: | 2001-06-23 |
½Ã°£: | 10:35:39 |
Á¶È¸¼ö: | 4860 |
from: | 211.33.8.94 |
|
                     [´äº¯] [´äº¯] [´äº¯] [´äº¯] [´äº¯] [´äº¯] [´äº¯] [Áú¹®] mysq |
±Û¾´ÀÌ : vopos |
|
>MYSQL¿¡¼ BLOBÇüÅÂÀÇ Ä÷³Àº ´ë¼Ò¹®ÀÚ¸¦ °¡·Á¼ >°Ë»öÇÏ´Â BINARY °Ë»öÀÌ ¾ÈµÇ³ªº»µ¥¿ä... > >ÀÌ ±â´ÉÀ» ¾µ¼ö ÀÖµµ·Ï ÇÏ·Á¸é ¾î¶² ¾Ë°í¸®Áò(?) >Çü½ÄÀ» ÃëÇØ¾ß Çϳª¿ä?
óÀ½¿¡ ÇϽŠÁú¹®Àä. ºÐ¸íÈ÷ ´ë¼Ò¹®ÀÚ¸¦ °¡·Á¼ °Ë»öÇÏ°Ú´Ù´Â Àǵµ¶ó°í »ý°¢ Çߴµ¥ ¾Æ´Ï±º¿ä.
´ë¼Ò¹®ÀÚ ±¸ºÐÇÏÁö ¾Ê°í °Ë»öÇÏ·Á¸é Ä÷³ µ¥ÀÌŸÇüÀ» TEXT·Î ¹Ù²Ù¸é µË´Ï´Ù. °£ ´ÜÇÏÁÒ. BLOB°ú TEXT´Â ´ë¼Ò¹®ÀÚÀÇ ±¸ºÐ À¯¹«¸¦ Á¦¿ÜÇÏ°ï ¸ðµç Ư¼ºÀÌ °°´Ù°í ¸Þ ´º¾ó¿¡ ³ª¿ÍÀÖ½À´Ï´Ù.
°¨»çÇÕ´Ï´Ù. Áñ°Å¿î µ¥ÀÌŸº£À̽º µÇ½Ã±æ...
- vopos
|
|
   |