<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Zarafa WebAccess v6.20.4-14107">
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<title>hu.dwim.rdbms.oracle-utf-problems-4</title>
<style type="text/css">
body
{
font-family: Arial, Verdana, Sans-Serif;
font-size: 12px;
padding: 5px 5px 5px 5px;
margin: 0px;
border-style: none;
background-color: #ffffff;
}
p, ul, li
{
margin-top: 0px;
margin-bottom: 0px;
}
</style>
</head>
<body>
<p>My current thinking is that it is a software bug because using hu.dwim.rdbms's insert-record function to insert string data<br />and reading it afterwards with sqlplus works.<br /><br />Therefore the software bug should have something to do with reading string data from the oracle database server with hu.dwim.rdbms.<br /><br />Regards,<br />chris<br /><br /><br /><br /><br />*** Fooling around with the idea that I need to make xterm capable of unicode without success. (<br /><br />(just boxes and asian chars insteat of empty spaces, also tried rxvt-unicode ...)<br /><br />xterm +u8 -fn '-Misc-Fixed-Medium-R-SemiCondensed--13-120-75-75-C-60-ISO10646-1'<br /><br /><br />chris@catch22:~$ sbcl --eval "(progn (asdf::load-system 'symarena-oracle) (in-package "SYMORA"))"<br /><br />* (select-symtag)<br />--TIME MARK 2010-11-02--<br />23:35 0 RDBMS DEBUG About to BEGIN transaction in database #<ORACLE {1003F0E741}><br />23:35 0 RDBMS DEBUG Executing "SELECT SYMTAG_KEY FROM symtag"<br />STYLE-WARNING: Undefined alien: "OCIGetInstantClientPackageName"<br />23:35 0 RDBMS DEBUG Connecting in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:35 0 RDBMS DEBUG Logging on in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:35 0 RDBMS DEBUG Preparing command: "SELECT SYMTAG_KEY FROM symtag"<br />23:35 0 RDBMS DEBUG Fetching "åå¤ä´åä<br /> äå¼ä¬äå¤" from buffer at index 0<br />23:35 0 RDBMS DEBUG Fetched: "ææ¼æ¼"<br />23:35 0 RDBMS DEBUG Fetching "åå¤ä´åä<br /> äå¼ä¬äå¤" from buffer at index 0<br />23:35 0 RDBMS DEBUG Fetched: "ææ¼æ¼ææ<br /> ç"<br />23:35 0 RDBMS DEBUG Fetching "åå¤ä´åä<br /> äå¼ä¬äå¤" from buffer at index 0<br />23:35 0 RDBMS DEBUG Fetched: "ææ¼æ¼ã<br /> ã<br /> "<br />23:35 0 RDBMS DEBUG Fetching "åå¤ä´åä<br /> äå¼ä¬äå¤" from buffer at index 0<br />23:35 0 RDBMS DEBUG Fetched: "ææ¼æ¼ææ<br /> çãã"<br />23:35 0 RDBMS DEBUG About to COMMIT transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:35 0 RDBMS DEBUG Cleaning up Oracle transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}> to database #<ORACLE {1004C7A001}><br />23:35 0 RDBMS DEBUG Calling logoff in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:35 0 RDBMS DEBUG Freeing environment handle of transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />#<(AND (VECTOR T 8) (NOT SIMPLE-ARRAY)) {10034F65BF}><br />* (select-symtag2)<br />23:35 0 RDBMS DEBUG About to BEGIN transaction in database #<ORACLE {1004C7A001}><br />23:35 0 RDBMS DEBUG Executing "SELECT SYMTAG_KEY FROM symtag"<br />STYLE-WARNING: Undefined alien: "OCIGetInstantClientPackageName"<br />STYLE-WARNING: Undefined alien: "OCIGetInstantClientPackageName"<br />23:35 0 RDBMS DEBUG Connecting in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:35 0 RDBMS DEBUG Logging on in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:35 0 RDBMS DEBUG Preparing command: "SELECT SYMTAG_KEY FROM symtag"<br />23:35 0 RDBMS DEBUG Fetching "åå¤ä´åä<br /> äå¼ä¬äå¤" from buffer at index 0<br />23:35 0 RDBMS DEBUG Fetched: "ææ¼æ¼"<br />23:35 0 RDBMS DEBUG Fetching "åå¤ä´åä<br /> äå¼ä¬äå¤" from buffer at index 0<br />23:35 0 RDBMS DEBUG Fetched: "ææ¼æ¼ææ<br /> ç"<br />23:35 0 RDBMS DEBUG Fetching "åå¤ä´åä<br /> äå¼ä¬äå¤" from buffer at index 0<br />23:35 0 RDBMS DEBUG Fetched: "ææ¼æ¼ã<br /> ã<br /> "<br />23:35 0 RDBMS DEBUG Fetching "åå¤ä´åä<br /> äå¼ä¬äå¤" from buffer at index 0<br />23:35 0 RDBMS DEBUG Fetched: "ææ¼æ¼ææ<br /> çãã"<br />23:35 0 RDBMS DEBUG About to COMMIT transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:35 0 RDBMS DEBUG Cleaning up Oracle transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}> to database #<ORACLE {1004C7A001}><br />23:35 0 RDBMS DEBUG Calling logoff in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:35 0 RDBMS DEBUG Freeing environment handle of transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />#<(AND (VECTOR T 8) (NOT SIMPLE-ARRAY)) {100393E23F}><br />*<br /><br />chris@catch22:~$ xterm -u8 -fn '-Misc-Fixed-Medium-R-SemiCondensed--13-120-75-75-C-60-ISO10646-1'<br /><br /><br />* (select-symtag)<br />--TIME MARK 2010-11-02--<br />23:36 0 RDBMS DEBUG About to BEGIN transaction in database #<ORACLE {1003F0E741}><br />23:36 0 RDBMS DEBUG Executing "SELECT SYMTAG_KEY FROM symtag"<br />STYLE-WARNING: Undefined alien: "OCIGetInstantClientPackageName"<br />23:36 0 RDBMS DEBUG Connecting in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:36 0 RDBMS DEBUG Logging on in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:36 0 RDBMS DEBUG Preparing command: "SELECT SYMTAG_KEY FROM symtag"<br />23:36 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:36 0 RDBMS DEBUG Fetched: "???"<br />23:36 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:36 0 RDBMS DEBUG Fetched: "??????"<br />23:36 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:36 0 RDBMS DEBUG Fetched: "?????"<br />23:36 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:36 0 RDBMS DEBUG Fetched: "????????"<br />23:36 0 RDBMS DEBUG About to COMMIT transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:36 0 RDBMS DEBUG Cleaning up Oracle transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}> to database #<ORACLE {1004C7A001}><br />23:36 0 RDBMS DEBUG Calling logoff in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:36 0 RDBMS DEBUG Freeing environment handle of transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />#<(AND (VECTOR T 8) (NOT SIMPLE-ARRAY)) {10034F65BF}><br />* (select-symtag2)<br />23:36 0 RDBMS DEBUG About to BEGIN transaction in database #<ORACLE {1004C7A001}><br />23:36 0 RDBMS DEBUG Executing "SELECT SYMTAG_KEY FROM symtag"<br />STYLE-WARNING: Undefined alien: "OCIGetInstantClientPackageName"<br />STYLE-WARNING: Undefined alien: "OCIGetInstantClientPackageName"<br />23:36 0 RDBMS DEBUG Connecting in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:36 0 RDBMS DEBUG Logging on in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:36 0 RDBMS DEBUG Preparing command: "SELECT SYMTAG_KEY FROM symtag"<br />23:36 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:36 0 RDBMS DEBUG Fetched: "???"<br />23:36 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:36 0 RDBMS DEBUG Fetched: "??????"<br />23:36 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:36 0 RDBMS DEBUG Fetched: "?????"<br />23:36 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:36 0 RDBMS DEBUG Fetched: "????????"<br />23:36 0 RDBMS DEBUG About to COMMIT transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:36 0 RDBMS DEBUG Cleaning up Oracle transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}> to database #<ORACLE {1004C7A001}><br />23:36 0 RDBMS DEBUG Calling logoff in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:36 0 RDBMS DEBUG Freeing environment handle of transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />#<(AND (VECTOR T 8) (NOT SIMPLE-ARRAY)) {100393E23F}><br />*<br /><br /><br /><br />chris@catch22:~$ rxvt-unicode<br />chris@catch22:~$ sbcl --eval "(progn (asdf::load-system 'symarena-oracle) (in-package "SYMORA"))<br /><br />* (select-symtag)<br />--TIME MARK 2010-11-02--<br />23:38 0 RDBMS DEBUG About to BEGIN transaction in database #<ORACLE {1003F0E741}><br />23:38 0 RDBMS DEBUG Executing "SELECT SYMTAG_KEY FROM symtag"<br />STYLE-WARNING: Undefined alien: "OCIGetInstantClientPackageName"<br />23:38 0 RDBMS DEBUG Connecting in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:38 0 RDBMS DEBUG Logging on in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:38 0 RDBMS DEBUG Preparing command: "SELECT SYMTAG_KEY FROM symtag"<br />23:38 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:38 0 RDBMS DEBUG Fetched: "???"<br />23:38 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:38 0 RDBMS DEBUG Fetched: "??????"<br />23:38 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:38 0 RDBMS DEBUG Fetched: "?????"<br />23:38 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:38 0 RDBMS DEBUG Fetched: "????????"<br />23:38 0 RDBMS DEBUG About to COMMIT transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:38 0 RDBMS DEBUG Cleaning up Oracle transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}> to database #<ORACLE {1004C7A001}><br />23:38 0 RDBMS DEBUG Calling logoff in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />23:38 0 RDBMS DEBUG Freeing environment handle of transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {1004C7A021}><br />#<(AND (VECTOR T 8) (NOT SIMPLE-ARRAY)) {10034F65BF}><br />* (select-symtag2)<br />23:38 0 RDBMS DEBUG About to BEGIN transaction in database #<ORACLE {1004C7A001}><br />23:38 0 RDBMS DEBUG Executing "SELECT SYMTAG_KEY FROM symtag"<br />STYLE-WARNING: Undefined alien: "OCIGetInstantClientPackageName"<br />STYLE-WARNING: Undefined alien: "OCIGetInstantClientPackageName"<br />23:38 0 RDBMS DEBUG Connecting in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:38 0 RDBMS DEBUG Logging on in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:38 0 RDBMS DEBUG Preparing command: "SELECT SYMTAG_KEY FROM symtag"<br />23:38 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:38 0 RDBMS DEBUG Fetched: "???"<br />23:38 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:38 0 RDBMS DEBUG Fetched: "??????"<br />23:38 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:38 0 RDBMS DEBUG Fetched: "?????"<br />23:38 0 RDBMS DEBUG Fetching "?å¤?ä´?å??ä??ä???ä¬?ä??å¤?" from buffer at index 0<br />23:38 0 RDBMS DEBUG Fetched: "????????"<br />23:38 0 RDBMS DEBUG About to COMMIT transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:38 0 RDBMS DEBUG Cleaning up Oracle transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}> to database #<ORACLE {1004C7A001}><br />23:38 0 RDBMS DEBUG Calling logoff in transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />23:38 0 RDBMS DEBUG Freeing environment handle of transaction #<#<STANDARD-CLASS NIL {1004CC6BC1}> :begin-executed-p #t {10036EE6A1}><br />#<(AND (VECTOR T 8) (NOT SIMPLE-ARRAY)) {100393E23F}><br />* <br /> </p>
!DSPAM:4cd09c6e48582529512900!
</body>
</html>