Support
Orange Support > 문의하기
Q & A
Re: Re: Re: 오렌지 특수문자 보이고, 안보이고 차이 문의
Date2021.03.22 /
Hit : 9610
Orange 4.0 || 4.0.1 ( Build:43 ) DBA Edition Enterprise License
2021/03/22 16:05:02
SQL> SELECT EML_SND_NO, TO_EML_CTNT
, rawtohex(cast(TO_EML_CTNT as varchar2(100)))
,dbms_lob.getlength(TO_EML_CTNT) as lob_size
,DUMP(cast(TO_EML_CTNT as varchar2(100))) AS CODE
,cast(TO_EML_CTNT as varchar2(100))
,ASCII(cast(TO_EML_CTNT as varchar2(100)))
rawtohex(TO_EML_CTNT)
FROM COM_EML_SND_INFO
WHERE EML_SND_NO IN (
2021030970229067EML,
2021030970230164EML,
2021030970229070EML,
2021030970230167EML,
2021031978772498EML,
2021011922210096EML)
EML_SND_NO TO_EML_CTNT LOB_SIZE CODE
- -
2021011922210096EML se.dl.buh.schenkerocean.invoicing@dbschenker.com 49 Typ=1 Len=49: 115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229067EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229070EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230164EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230167EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021031978772498EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
6 rows selected.
Execution Time: 00:00:00.94
Elapsed Time: 00:00:01.156
Orange 7.0 // Version 7.0.1 ( Build : 116 _ DBA Edition Enterprise License
-[Start Time: 2021/03/22 16:05:36]-
SQL> SELECT EML_SND_NO, TO_EML_CTNT
, rawtohex(cast(TO_EML_CTNT as varchar2(100)))
,dbms_lob.getlength(TO_EML_CTNT) as lob_size
,DUMP(cast(TO_EML_CTNT as varchar2(100))) AS CODE
,cast(TO_EML_CTNT as varchar2(100))
,ASCII(cast(TO_EML_CTNT as varchar2(100)))
rawtohex(TO_EML_CTNT)
FROM COM_EML_SND_INFO
WHERE EML_SND_NO IN (
2021030970229067EML,
2021030970230164EML,
2021030970229070EML,
2021030970230167EML,
2021031978772498EML,
2021011922210096EML)
EML_SND_NO TO_EML_CTNT LOB_SIZE CODE
- -
2021011922210096EML se.dl.buh.schenkerocean.invoicing@dbschenker.com 49 Typ=1 Len=49: 115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229067EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229070EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230164EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230167EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021031978772498EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
6 rows selected.
2021/03/22 16:05:02
SQL> SELECT EML_SND_NO, TO_EML_CTNT
, rawtohex(cast(TO_EML_CTNT as varchar2(100)))
,dbms_lob.getlength(TO_EML_CTNT) as lob_size
,DUMP(cast(TO_EML_CTNT as varchar2(100))) AS CODE
,cast(TO_EML_CTNT as varchar2(100))
,ASCII(cast(TO_EML_CTNT as varchar2(100)))
rawtohex(TO_EML_CTNT)
FROM COM_EML_SND_INFO
WHERE EML_SND_NO IN (
2021030970229067EML,
2021030970230164EML,
2021030970229070EML,
2021030970230167EML,
2021031978772498EML,
2021011922210096EML)
EML_SND_NO TO_EML_CTNT LOB_SIZE CODE
- -
2021011922210096EML se.dl.buh.schenkerocean.invoicing@dbschenker.com 49 Typ=1 Len=49: 115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229067EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229070EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230164EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230167EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021031978772498EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
6 rows selected.
Execution Time: 00:00:00.94
Elapsed Time: 00:00:01.156
Orange 7.0 // Version 7.0.1 ( Build : 116 _ DBA Edition Enterprise License
-[Start Time: 2021/03/22 16:05:36]-
SQL> SELECT EML_SND_NO, TO_EML_CTNT
, rawtohex(cast(TO_EML_CTNT as varchar2(100)))
,dbms_lob.getlength(TO_EML_CTNT) as lob_size
,DUMP(cast(TO_EML_CTNT as varchar2(100))) AS CODE
,cast(TO_EML_CTNT as varchar2(100))
,ASCII(cast(TO_EML_CTNT as varchar2(100)))
rawtohex(TO_EML_CTNT)
FROM COM_EML_SND_INFO
WHERE EML_SND_NO IN (
2021030970229067EML,
2021030970230164EML,
2021030970229070EML,
2021030970230167EML,
2021031978772498EML,
2021011922210096EML)
EML_SND_NO TO_EML_CTNT LOB_SIZE CODE
- -
2021011922210096EML se.dl.buh.schenkerocean.invoicing@dbschenker.com 49 Typ=1 Len=49: 115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229067EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229070EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230164EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230167EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021031978772498EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
6 rows selected.
오렌지 특수문자 보이고, 안보이고 차이 문의
장태길
2021.03.22
Re: 오렌지 특수문자 보이고, 안보이고 차이 문의
오렌지팀
2021.03.22
Re: Re: 오렌지 특수문자 보이고, 안보이고 차이 문의
장태길
2021.03.22
Re: Re: Re: 오렌지 특수문자 보이고, 안보이고 차이 문의
장태길
2021.03.22
Re: Re: Re: Re: 오렌지 특수문자 보이고, 안보이고 차이 문의
장태길
2021.03.22
Re: Re: Re: 오렌지 특수문자 보이고, 안보이고 차이 문의
오렌지팀
2021.03.23