PHP에서 MSSQL서버로 접속해서 XML형태의 데이타를 넣을때
Update Failed because SET option CONCAT_NULL_YIELDS_NULL 어쩌구 저쩌구
이렇게 뜨면 아래 내용참고 해서 SET Option을 조절해 준다.
ODBC를 이용할때 기본적으론 해당 옵션이 켜져있지 않은 모양.
Robert at realjax dot com
14-Jun-2005 10:00
A view that worked fine when queried from any other environment was giving me strange results when queried from PHP
. The problem is that the MS SQL database settings are not set to the ANSI defaults as when connecting through Microsoft products. The setting CONCAT_NULL_YIELDS_NULL defaults to ON when connecting with ODBC or SQL Query Analyzer, which complies with the ANSI standard. However, this defaults to OFF when connecting through PHP. There are many other settings which may also need to be explicitly set.
<?php
mssql_query(‘SET CONCAT_NULL_YIELDS_NULL ON’, $hd);
?> 우왕ㅋ굳ㅋ
땡큐 로버트