Devart Forums

Hi!

I have found a problem of the korean charset in the laste ODAC Net Edition version

" SELECT a.msgkey, a.phone, a.callback,
decode(nvl(b.status, '0'), '1', '전송중', '2', '전송완료', '대기') as status,
b.status,
a.msg, a.etc2
FROM TB_SMS_MSG a, kenca.sms_log b
WHERE a.msgkey = b.msgkey(+)
AND a.etc2 = '등록'
AND a.etc1 = :p_reqnum
ORDER BY a.msgkey "

in TOraQuery and then put Active=True
I get all the time "ORA-00907: missing right parenthesis"

I know the statement is OK...
I'm try to check this SQL statement with "SQL Plus" Oracle tool , OK Execute

"decode(nvl(b.status, '0'), '1', '전송중', '2', '전송완료', '대기') as status "
this sentence Dont't execute, but
"decode(nvl(b.status, '0'), '1', '등록', '2', '미등록', '등록') as status "
this sentence is execute OK
I guess Don't execute korean Charset in ODAC Net Edition version


P.S.
ODAC Net Edition v5.80, Oracle it, Win XP Professional SP2 (korea), Delphi 7

try to TOraSession Set is
TOraSession.Options.CharLength := 0;
TOraSession.Options.Charset := 'UTF8';
TOraSession.Options.ConvertEOL := False
TOraSession.Options.DateFormat : YYYY-MM-DD
TOraSession.Options.DateLanguage := KOREAN
TOraSession.Options.Net := True;
TOraSession.Options.UseUnicode := False or True;

Please~ Would you solve this problem?

-- in The South Korea, Seoul

ODAC doesn't support Unicode characters in SQL text. Please try to use parameters instead.