엑셀로 데이터 올리기 할때 string 내에 '가 ''로 입력됨

다음 테이블 생성후 첨부 되는 파일을 쿼리 브라우져를 사용하여 로딩

create table enkr_entry_0227_tmp
ALTER CLASS enkr_entry_0227_tmp ADD ATTRIBUTE
entry_nm character varying(200) NOT NULL,
property character varying(200),
entry_type character(1) NOT NULL,
from_id character varying(200),
header character varying(100),
search_nm character varying(200),
pub_lev character(1),
superscript numeric(1,0),
brand character(1) NOT NULL,
posps character varying(100),
study_id character varying(200),
differ_body character varying(200),
gdid character(21),
from_language character varying(200),
search_nm_nospec character varying(200),
dic_id character varying(20),
entry_id character varying(32) NOT NULL,
high_df_term character(1),
title_entry_nm character varying(200),
use_yn character(1) DEFAULT 'Y',
dic_type character varying(2) NOT NULL,
cre_ymdt timestamp,
up_ymdt timestamp,
up_user_id character varying(100),
up_user_nm character varying(100),
bestquery character varying(200);

ALTER CLASS enkr_entry_0227_tmp ADD ATTRIBUTE
CONSTRAINT "pk_enkr_entry_0227_tmp_entry_id" PRIMARY KEY(entry_id);

확인 쿼리
SELECT * FROM ENKR_ENTRY_0227_tmp WHERE ENTRY_NM LIKE '%''%' and dic_type IN ('UN','UO') and entry_id > '0'

결과
'Coulomb''s friction' '' 'M' '' '' 'Coulomb''s frictio
n' '0' NULL 'N' '' '' ''
'08115C28000001281922 ' '' 'Coulombs friction' '1281922' '0022b4afc0a84b16bec81e46d1b22fe6' '
' 'Coulomb''s friction' 'Y' 'UO' NULL NULL
NULL NULL NULL
'Rosin-Rammler''s formula' NULL 'M' NULL NULL 'Rosin-Rammler
''s formula' '0' NULL 'N'

정상결과(다음과 같이 결과가 나타나야 함)

• 아래는 동일한 파일을 CUBRID manager를 통해 로딩한 데이터를 select한 결과임
  'Coulomb's friction' '' 'M' '' '' 'Coulomb's friction'
  '0' NULL 'N' '' '' ''
  '08115C28000001281922 ' '' 'Coulombs friction' '1281922' '0022b4afc0a84b16bec81e46d1b22fe6' ' '
  'Coulomb's friction' 'Y' 'UO' NULL NULL
  NULL NULL NULL
  'Rosin-Rammler's formula' NULL 'M' NULL NULL 'Rosin-Rammler'
  s formula' '0' NULL 'N' '' NULL ''
  '08115C25000001278156 ' NULL 'Rosin Rammlers formula' '1278156' '0186231ced7b429880594e2d
  592967bc' NULL 'Rosin-Rammler's formula' 'Y' 'UN' NULL N
  ULL NULL NULL NULL
  'Stoke's law' NULL 'M' NULL NULL 'Stoke's law'
  '0' NULL 'N'