C + POSTGRESQL사용하여 작업중입니다. 아래의 데이터를 INSERT하려는 데 에러 발생
1. 인서트할 데이터
367 TCP DATA FIELD TESTING(after)
368 TCP DATA(cid : sport : dport : data) = 4181 : 2668 : 23 : 24 May 2000 16:23:24 GMT by aegisfw.aegis.co.kr (<a href= http://squid.nlanr.net/Squid/ >Squid/2.2.STABLE1</a>)
369 </BODY></HTML>
370 : 1311^M
371 Expires: Wed 24 May 2000 16:23:24 GMT^M
372 X/Squid/Error: ERR_INVALID_URL 0^M
373 X/Cache: MISS from aegisfw.aegis.co.kr^M
374 Proxy/Connection: close^M
375 ^M
376 <HTML><HEAD>
377 <TITLE>ERROR: The requested URL could not be retrieved</TITLE>
378 </HEAD><BODY>
379 <H1>ERROR</H1>
380 <H2>The requested URL could not be retrieved</H2>
381 <HR>
382 <P>
383 While trying to retrieve the URL:
384 <A HREF= http://channels.real.com/getlatest.glh?PV=6.0.6.99&OS=WIN&L=en/US en *&LID=1033&ch=120+54+0+0+0&ch=72+39+0+0+0&ch=44+287+0+0+0&ch=52+505+0+0+0&ch=33+393+0+0+0&ch=73+19+0+0+0&ch=98+27+0+0+0&ch=94+244+0+0+0&ch=16+478+0+0+0&ch=113+46+0+0+0&ch=51+116+0+0+0&ch=97+108+0+0+0 >http://channels.real.com/getlatest.glh?PV=6.0.6.99&OS=WIN&L=en/US en *&LID=1033&ch=120+54+0+0+0&ch=72+39+0+0+0&ch=44+287+0+0+0&ch=52+505+0+0+0&ch=33+393+0+0+0&ch=73+19+0+0+0&ch=98+27+0+0+0&ch=94+244+0+0+0&ch=16+478+0+0+0&ch=113+46+0+0+0&ch=51+116+0+0+0&ch=97+108+0+0+0</A>
385 <P>
386 The following error was encountered:
387 <UL>
388 <LI>
389 <STRONG>
390 Invalid URL
391 </STRONG>
392 </UL>
393
394 <P>
395 Some aspect of the requested URL is incorrect. Possible problems:
396 <UL>
397 <LI>Missing or incorrect access protocol (should be http:// or similar)
398 <LI>Missing hostname
399 <LI>Illegal double/escape in the URL/Path
400 <LI>Illegal character in hostname; underscores are not allowed
401 </UL>
402 </P>
403
404 <br clear= all >
405 <hr noshade si
이상의 데이터입니다.
결과
ERROR: Unterminated quoted string
제가 임의로 ESCAPE CHARACTER 몇몇('"`)을 제거했음에도 위의 에러가 발생합니다.
혹시 또 다른 어떤 데이터를 제거해야 하는 지 알고 계시면 도와주세요.....
|