select * from hdwz021dm9
where ws_auth_name ='박형준'
and ws_from_weekdate ='20050612'
and ws_to_weekdate ='20050618'
and ws_lst_login_ip ='130.7.17.132'
and ws_cstm_name ='인천공항세관'
이런 쿼리를 날리면 저는
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
Error: String data translation caused data truncation.
(State:01004, Native Code: 0)
Error: Unclosed quote before the character string '인천공'.
(State:HY000, Native Code: 69)
Error: Incorrect syntax near '인천공'.
(State:42000, Native Code: 66)
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
이런 에러가 생깁니다 다른분 컴에서 하면
아무런 장애없이 잘실행되고요 웃긴것은
and ws_cstm_name ='인천공항세관'요부분 없애고 하면 잘됩니다
그런데 똑같은 형식으로 update하면 and ws_to_weekdate
='20050618'
and ws_lst_login_ip ='130.7.17.132'
and ws_cstm_name ='인천공항세관' 만큼 없애야 되고요 ;;;왜이럴까요
다른분 컴에서는 모든것이
잘되는데 ㅡㅠ 설정상문제일까요 ;;;
|