oracle apache phpÂÒÂëÎÊÌâ
°ì·¨Ò»
select * from V$NLS_PARAMETERS
$conn = oci_connect('scott', 'donkey', 'demo', 'zhs16gbk');
while ($dat = oci_fetch_row($cur)) {
print_r(iconv('gb2312', 'utf-8', $dat[0])); //$nickname = mb_convert_encoding($dat[0], 'utf-8', 'gbk');
}
»òÕß $c1 = oci_connect("scott", "tiger", $db, 'UTF8');
°ì·¨¶þ£º
°²×°ºÃ·þÎñÆ÷ºó£¬Óÿͻ§¶Ë¿´·þÎñÆ÷µÄÓïÑÔ
sql>select * from V$NLS_PARAMETERS Where PARAMETER=''NLS_LANGUAGE'';
±ÈÈç½á¹ûÊÇ"SIMPLIFIED CHINESE”
ÔÚApacheÀï¼ÓÈë»·¾³±äÁ¿
export NLS_LANGUAGE="SIMPLIFIED CHINESE"
ÔÚ/etc/init.d/httpdÀï¼ÓÈ룬Դ´úÂë°²×°µÄApacheдһ¸ö½Å±¾µ÷ÓÃapachectl
»òÕßÐèÒª/etc/init.d/httpdÀï¼ÓÈëÀïÒýÈë»·¾³±äÁ¿£¬ÓÉÓÚ±¾»úûÓÐÄǸöÆô¶¯Îļþ£¬ËùÒÔÖ»ÄÜÔÚapachectlÀï¼ÓÈëÈçÏ´úÂ룺
export NLS_LANGUAGE="SIMPLIFIED CHINESE"¡£
·½·¨Èý£ºhttpd.confÀï¼ÓÒ»ÐÐAddDefaultCharset GB2312 /off
·½·¨ËÄ£ºhtmlspecialchars() Ö§³ÖË«×Ö½Ú×Ö·û£¬±ÈÈ纺×Ö
htmlentities()Ö§³Öµ¥×Ö½Ú×Ö·û
·½·¨Î壺apacheµÄÅäÖÃÎļþÒѾ¼ÓÁËAddDefaultCharset GB2312
phpµÄÅäÖÃÎļþÒѾ¼ÓÁË AddDefaultCharset GB2312
Ïà¹ØÎĵµ£º
ÔÚÐéÄâ»úRed Hat Enterprise Linux 4 update 4Öа²×°oracle 10.2.0.1
1)²é¿´ÏµÍ³ÄÚ´æ
[root@linux4 ~]# grep MemTotal /proc/meminfo
2)²é¿´½»»»Çø´óС
[root@linux4 ~]# grep SwapTotal /proc/meminfo
3)
²é¿´/tmpĿ¼´óС
[root@linux4 ~]# df -m /tmp
4)²é¿´²Ù×÷ϵͳ°æ±¾
[root@linux4 ~]# cat /etc/issue
5)¼ ......
×÷ΪʵÏÖ¶¯Ì¬ÍøÕ¾µÄ¹¤¾ßÖ®Ò»£¬PHPÒÔÆäÓï·¨¼òµ¥¡¢¸ßЧ¿ìËٺͶÔÊý¾Ý¿âµÄ¹ã·ºÖ§³Ö¶øÉîÊÜÓû§»¶Ó¡£±àдPHP³ÌÐòºÍASPÒ»ÑùÐèÒªÔÚ±¾»úµ÷ÊÔ£¬Îª´ËÐèÒªÅäÖÃһϵ÷ÊÔ»·¾³¡£
Óкܶ෽°¸¿ÉÒÔÑ¡Ôñ£¬ÕâÀïÌṩÁ½ÖÖ½ÏΪ¼òÒ׵ķ½·¨¡£
²»¹ÜÊÇÄÄÖÖ·½·¨£¬¶¼ÐèÒª°²×°PHP¡£Èç¹ûÄãÊÇPHPʹÓÃÕߣ¬Äã¿ÉÄÜÔÚÍøÉÏÕÒ¹ýPHPµÄ°²×°×ÊѶ£¬ËüÃǼ¸ºõ¶¼ËµµÄ ......
ÔÚPHPÖÐʹÓùýSESSIONµÄÅóÓÑ¿ÉÄÜ»áÅöµ½Õâôһ¸öÎÊÌ⣬ÔÚijЩ¿Í»§¶ËµçÄÔÉÏSESSION±äÁ¿²»ÄÜ¿çÒ³´«µÝ¡£ÕâÁîÎÒ¿àÄÕÁ˺ÃЩÈÕ×Ó£¬×îÖÕͨ¹ý²é×ÊÁÏ˼¿¼²¢½â¾öÁËÕâ¸öÎÊÌâ¡£ÎÒÈÏΪ£¬³öÏÖÕâ¸öÎÊÌâµÄÔÒòÓÐÒÔϼ¸µã£º
1¡¢¿Í»§¶Ë½ûÓÃÁËcookie
2¡¢ä¯ÀÀÆ÷³öÏÖÎÊÌ⣬ÔÝʱÎÞ·¨´æÈ¡cookie
3¡¢php.iniÖеÄsession.use_trans_sid = 0»òÕß±àÒë ......
PHP5.2.4֮ǰµÄ°æ±¾ÎÞÐèÉèÖÃÊ±Çø¡£ÏÂÃæÊÇÐÞ¸ÄPHPÊ±ÇøµÄÈý¸ö°ì·¨¡£
1¡¢ÐÞ¸ÄPHP.iniÕâ¸öÎļþ
ÕÒµ½date.timezoneÕâÐУ¬È¥µôÇ°ÃæµÄ·ÖºÅ£¬¸Ä³É£º date.timezone = Asia/Shanghai 2¡¢ÐÞ¸Ä .htaccessÎļþ
ÐÞ¸Ä.htaccessÎļþÓÐÁ½ÖÖ°ì·¨£¬ÏÂÃæµÄÁ½ÌõÓï¾äÖ»ÒªÓÐÒ»Ìõ¼´¿É php_value date.timezone Asia/Shanghai
......
oracleÀïµÄ³£ÓÃÃüÁîÏê½â
±¾ÎÄÕë¶ÔoracleÈÕ³£µÄÃûÁî×öÁ˽éÉÜ£¬»¶Ó¸÷λ´óÏÀ¶àÌᱦ¹óÒâ¼ûºÍ¶à¶à²¹³ä£¡
Ò»
ÈÕÖ¾¹ÜÀí
1.forcing log switches
sql> alter system switch logfile;
2.forcing checkpoints
sql> alter system checkpoint;
3.adding online redo log groups
sql> alter database add logfil ......