2008年7月 7日

[openoffice:11163] Re: Base¤ÎËÝÌõ¤Ë¤Ä¤¤¤Æ

¤ªÈè¤ìÍͤǤ¹¡£

¤È¤ê¤¢¤¨¤º¡¢ÍѸì NULL ¤Ë¤Ä¤¤¤Æ Issue ÅÐÏ¿¤¤¤¿¤·¤Þ¤·¤¿¡£

OpenOffice.org 3.0 ¤Î³«È¯ÈǤˤª¤¤¤ÆÄ´¤Ù¤Æ¤ß¤¿¤È¤³¤í¡¢ÀìÌçÍѸì¤Ç¤¢¤ë
NULL ¤¬ 49 ²Õ½ê¤Ç»È¤ï¤ì¤Æ¤¤¤Þ¤·¤¿¡£

¤½¤Î¤¦¤Á¤Î¤¤¤¯¤Ä¤«¤Ç¡¢NULL ¤¬¡¢¥¼¥í¡¢¶õ¡¢¶õÇò¡¢¥Ì¥ë¡¢¤Ê¤É¤ÈÌõ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£

¤³¤Î NULL ¤Ë¤Ä¤¤¤Æ¤Ï¡¢Ìõ¤µ¤º¤Ë NULL ¤Î¤Þ¤Þ¤È¤¹¤ë¤Ù¤­¤Ç¤Ï¤Ê¤¤¤«¤È»×¤¤¤Þ¤¹¡£

[JA] A technical term 'NULL' should be left untranslated
http://www.openoffice.org/issues/show_bug.cgi?id=91409
http://www.openoffice.org/nonav/issues/showattachment.cgi/54964/91409_resouces_including_a_term_NULL_revised.ods

¸Ä¡¹¤Î¹àÌܤÎÌõ¤Ä¤¤¤Æ¡¢¤½¤ì¤¾¤ì¸ÄÊ̤ËÊÌÅÓµÄÏÀ¤·¤¿¤Û¤¦¤¬¤è¤¤¹àÌܤ⤢¤ë¤«¤È»×¤¤¤Þ¤¹¡£

¹àÌܤϡ¢¥æ¡¼¥¶¡¼¥¤¥ó¥¿¡¼¥Õ¥§¡¼¥¹¾å¤Î¥À¥¤¥¢¥í¥°¾å¤Ê¤É¤Ë½Ð¤Æ¤¯¤ëÌõ¤È¡¢
¥ª¥ó¥é¥¤¥ó¥Ø¥ë¥×¾å¤Ë½Ð¤Æ¤¯¤ëÌõ¤È¤¬¤¢¤ê¤Þ¤¹¡£

¥À¥¤¥¢¥í¥°¾å¤Ê¤É¤Ë½Ð¤Æ¤¯¤ëÌõ¤Ç¤Ï¡¢¤½¤Î¥À¥¤¥¢¥í¥°Æâ¤Ç¤ÎÌò³ä¤Ê¤É¤Ë±þ¤¸¤Æ
ŬÀÚ¤ÊÌõ¤òÁª¤ÖɬÍפ¬¤¢¤ë¤«¤È»×¤¤¤Þ¤¹¡£¤½¤·¤Æ¡¢¤½¤Î¹»Àµ¸å¤ÎÌõ¤òÂбþ¤¹¤ë
¥ª¥ó¥é¥¤¥ó¥Ø¥ë¥×¤ÎÌõ¤Ë¤âÈ¿±Ç¤µ¤»¤ëɬÍפ⤢¤ë¤«¤È»×¤¤¤Þ¤¹¡£

¤Þ¤¢¡¢¤È¤Ë¤«¤¯¡¢ÀìÌçÍѸì NULL ¤Ë¤Ä¤¤¤Æ¤´¶½Ì£¤Î¤¢¤ë¿Í¤Ï¡¢¤È¤ê¤¢¤¨¤º¡¢
¾åµ­¤Î .ods ¥Õ¥¡¥¤¥ë¤ÎÆâÍÆ¤ò¤´Í÷¤Ë¤Ê¤Ã¤Æ¤¤¤¿¤À¤±¤Þ¤»¤ó¤Ç¤·¤ç¤¦¤«¡£

# ºÇ¶á¤ªÊÖ»ö¤Ç¤­¤Æ¤¤¤Ê¤¤¥á¡¼¥ë¤Ë¤Ä¤¤¤Æ¤Ï¡¢ÃÙ¤ì¤Ð¤»¤Ê¤¬¤é¡¢½ç¼¡¤ªÊÖ»ö¤¤¤¿¤·¤Þ¤¹¤Í¡£

Tora

Masahisa Kamataki wrote:
> ¥¯¥¨¥ê¤Ç¤ÎEMPTY¶ç¤Îưºî¤¬¤ª¤«¤·¤¤ :
> http://oooug.jp/faq/index.php?faq/4/1128
>
> ¤Î¼ÁÌ䤫¤éUIËÝÌõ¤Ë´Ø¤¹¤ëµ¿ÌäÅÀ¤ò´¶¤¸¤Þ¤·¤¿¡£¡ÖOpenOffice.org Q&A¡×¤Ç¤Ï¡¢
> ±ÜÍ÷¤¹¤ëÊý¤Ë¸Â¤ê¤¬¤¢¤ë¤Î¤Ç¡¢Åö¥á¡¼¥ê¥ó¥°¥ê¥¹¥È¤ÎÊý¡¹¤Ë¤â°Õ¸«¤òµá¤á¤¿¤¤
> ¤È»×¤¤¤Þ¤¹¡£
>
> ¼ÁÌ䤽¤Î¤â¤Î¤Ï Base+HSQLDB(ɸ½à¤ÎDB)¤ÎNULLÃͤˤĤ¤¤Æ¤Î¤â¤Î¤Ç¤¹¡£¥Æ¡¼¥Ö
> ¥ë¤ÇÆþÎϤ¹¤ë¾ì¹ç¤ÏNULL¥Ç¥Õ¥©¥ë¥È¤Î¥Æ¡¼¥Ö¥ë¤Î¥Õ¥£¡¼¥ë¥É¤Ë¡¢Ä¹¤µ¤¬0¤Îʸ
> »úÎó(¶õÇòÃÍ)¤òÆþÎϤǤ­¤Þ¤»¤ó¡£
>
> ¤·¤«¤·¡¢¥Õ¥©¡¼¥à¤Ë¤Æ¥Æ¥¯¥¹¥È¥Ü¥Ã¥¯¥¹¥³¥ó¥È¥í¡¼¥ë¤Î°À­¤òÊѹ¹¤¹¤ë¤³¤È¤Ç
> ¶õÇòÃͤòÆþÎϲÄǽ¤Ë¤Ç¤­¤Þ¤¹¡£¤½¤ÎÀßÄê²èÌ̤¬
> http://oooug.jp/faq/index.php?plugin=ref&page=faq%2F4%2F1128&src=faq4_1128_1.png
> ¤Ç¤¹¡£
>
> ³§¤µ¤ó¤Ë¤ªÊ¹¤­¤·¤¿¤¤¤³¤È¤Î¡¢¤½¤Î1¤Ï¤³¤ÎUI¤ÎËÝÌõ¤Ç¤¹¡£
>
> ¾åµ­²èÁü¤Î¡Ö¶õÇò¤Îʸ»úÎó¤Ï¥¼¥í¤È¤ß¤Ê¤¹¡×Íó¤¬ÀßÄê²Õ½ê¤Ç¤¹¤¬¡¢¤³¤Î¸¶Ê¸¤Ï
> "Empty string is NULL"¤Ç¤¹¡£¤Ä¤Þ¤ê¡ÖNULL¡×¤¬¡Ö¥¼¥í¡×¤ÈÌõ¤µ¤ì¤Æ¤·¤Þ¤Ã¤Æ
> ¤¤¤Þ¤¹¡£
>
> ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ç¤Ï¡ÖNULL¡×¤Ï̤ÆþÎϤξõÂÖ¤òɽ¤·¤Þ¤¹¡£¤Þ¤¿¡¢ÆþÎÏÃͤ¬ºï½ü¤µ
> ¤ì¤¿¾õÂÖ¡¢¤Ä¤Þ¤êʸ»úÎó¤ÎŤµ¤¬0(¥¼¥í)¤È¤Ï¶èÊ̤µ¤ì¤Þ¤¹¡£¤·¤¿¤¬¤Ã¤Æ¡ÖNULL¡×
> ¤Ï¡ÖNULL¡×¤Î¤Þ¤Þ¤Î¤Û¤¦¤¬¸í²ò¤µ¤ì¤Ë¤¯¤¯¤Ê¤ê¤Þ¤¹¡£
>
> ¾åµ­¤ÎUI¤Ï¡Ö¶õÇò¤Îʸ»úÎó¤ÏNULL¤È¤ß¤Ê¤¹¡×¤È¤¤¤¦Ìõ¤¬Îɤ¤¤À¤í¤¦¤È»×¤¤¤Þ¤¹¡£
>
> ¤µ¤Æ¡¢¤â¤¦1ÅÀ¤Ï¥Ø¥ë¥×¤ÎËÝÌõ¤Ç¤¹¡£
>
> http://oooug.jp/faq/index.php?faq/4/1128 ¤Ç¤Ï¡¢¤µ¤é¤Ë Tora ¤µ¤ó¤«¤é¥Ø
> ¥ë¥×¤ÎÆâÍÆ¤ËÉÕ¤¤¤Æ¤â¡¢µ¿ÌäÅÀ¤¬¾å¤²¤é¤ì¤Þ¤·¤¿¡£
>
> ¸½ºß¤ÎÆüËܸì
>
> ¶õ¤Îʸ»úÎó¤Ï¡¢NULL
> ¶õÇòʸ»úÎ󤬯þÎϤµ¤ì¤¿¾ì¹ç¤Î½èÍýË¡¤ò»ØÄꤷ¤Þ¤¹¡£ ¤³¤Î°À­¤ò (¤Ï¤¤) ¤ËÀßÄê
> ¤·¤Æ¤ª¤¯¤È¡¢¥¹¥Ú¡¼¥¹µ­¹æ¤Î¤ß¤«¤éÀ®¤ëʸ»úÎó¤Ï¡¢NULL ÃͤȤ·¤Æ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë
> ³ÊǼ¤µ¤ì¤Þ¤¹¡£¤³¤Î°À­¤ò (¤¤¤¤¤¨) ¤ËÀßÄꤷ¤Æ¤ª¤¯¤È¡¢¤³¤¦¤·¤¿Ê¸»úÎó¤Ï¶õÇòÃÍ
> ¤È¤·¤Æ½èÍý¤µ¤ì¤Þ¤¹¡£
>
> ±Ñ¸ì¤Î¸¶Ê¸
>
> Empty string is NULL
> Defines how an empty string input should be handled. If this
> property is set (Yes), a string with only one or more spaces
> will be interpreted as a NULL value and stored in the database.
> If this property is not set (No), the string will be treated
> as an empty value.
>
> ±Ñ¸ì¤Î¸¶Ê¸¤Ï http://oooug.jp/faq/index.php?faq/4/1128 ¤ËźÉÕ¤·
> ¤¿¥µ¥ó¥×¥ë¤Î faq4_1128_1.odb ¤Îưºî¤ò¸«¤ë¤È¤ª¤«¤·¤¤¤Ç¤¹¡£
>
> ±Ñ¸ì¤Î¸¶Ê¸"a string with only one or more spaces"¤Ï¡¢"1¤Ä¡¢¤â¤·¤¯¤Ï¤½
> ¤ì°Ê¾å¤Î¥¹¥Ú¡¼¥¹¤«¤é¤Ê¤ëʸ»úÎó"¤È¤¤¤¦¤³¤È¤Ç¤¹¤¬¡¢¤³¤ì¤é¤Ï¡¢¡Ö¶õÇò¤Îʸ
> »úÎó¤Ï¥¼¥í¤È¤ß¤Ê¤¹(Empty string is NULL)¡×Í󤬡֤Ϥ¤¡×¤Î¾õÂ֤Ǥϡ¢¤½¤Î
> ¤Þ¤Þ¥¹¥Ú¡¼¥¹¤È¤·¤Æ¥Õ¥£¡¼¥ë¥É¤Ë³ÊǼ¤µ¤ì¤Þ¤¹¡£NULL¤Ë¤Ï¤Ê¤ê¤Þ¤»¤ó¡£
>
> ËÜÍè¤ÎDB¤Îưºî¤«¤é¤¹¤ë¤È¡¢¡Ö´û¸¤ÎÃͤòºï½ü¤¹¤ë¤è¤¦¤ÊŤµ¤¬0¤Îʸ»úÎó¡×
> ¤Ë¤¢¤¿¤ë¤è¤¦¤Ê±Ñ¸ì¤Î¸¶Ê¸¤Ç¤Ê¤¤¤È¤¤¤±¤Ê¤¤¤È»×¤¤¤Þ¤¹¡£
>
> ¤ß¤Ê¤µ¤ó¤Î¤´°Õ¸«¤ò¤ª»Ç¤¤¤·¤¿¤¤¤È»×¤¤¤Þ¤¹¡£
>
> ;; Tora ¤µ¤ó¡¢ML¤Ç¤â°Õ¸«¤òʹ¤­¤Þ¤·¤ç¤¦¡£
>

¡ÚML¥³¥ß¥å¥Û¡¼¥à¥Ú¡¼¥¸¡ http://www.freeml.com/openoffice

--[PR]------------------------------------------------------------------
¡¡Ìµ¨­ÎÁ¨­¡ª¨­¼«¨­Æ°¨­¼Ö¨­Êݨ­¸±¨­¤ò¨­°ì¨­³ç¨­¸«¨­ÀѨ­¤â¨­¤ê¨­¡ù¨­
¡¡¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°¨¬¨°
¡¡¡¡¡¡¡ù¡ù¡ú¡¡ÊØÍø¤Ê¥¤¥ó¥¿¡¼¥Í¥Ã¥È¸«ÀѤâ¤ê¡ªºÇû5ʬ¡ª¡¡¡ú¡ù¡ù
¡¡¢¡¢¡¡¡º£¤Ê¤é¡ª¤â¤ì¤Ê¤¯¥Þ¥Ã¥¯¥«¡¼¥É500±ßʬ¤ò¥×¥ì¥¼¥ó¥È¡ª¡¡¢¡¢¡
http://ad.freeml.com/cgi-bin/sa.cgi?id=ci9C6
------------------------------------------------------------------[PR]--
¢£GMO INTERNET GROUP¢£ GMO INTERNET www.gmo.jp


Åê¹Æ¼Ô xml-rpc : 2008年7月 7日 02:41
Ìò¤ËΩ¤Á¤Þ¤·¤¿¡©¡§
²áµî¤Î¥Õ¥£¡¼¥É¥Ð¥Ã¥¯ Ê¿¶Ñ:(0) Áí¹ç:(0) Åêɼ²ó¿ô:(0)
Ëܵ­»ö¤Ø¤ÎTrackback: http://hoop.euqset.org/blog/mt-tb2006.cgi/75060
¥È¥é¥Ã¥¯¥Ð¥Ã¥¯
¥³¥á¥ó¥È
¥³¥á¥ó¥È¤¹¤ë




²èÁü¤ÎÃæ¤Ë¸«¤¨¤ëʸ»ú¤òÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£