In ODAC query Oracle database, query the field content for a maximum of 10 characters, redundant character is automatically removed, what reason be?
The code below
Orasession1. Options. Direct:=true;
Orasession1. Server:='127.0.0.1:1521: wouldn';
Orasession1. Username:='username';
Orasession1. Password:='password';
Orasession1. Options. Charset:='ZHS16GBK';
Orasession1. Connected:=true;

Oraquery1. SQL. Text:='select jh as "pound sign" the from jhtable';
Oraquery1. Open;

In searching after the well number, why the data retrieved 10 characters can only display?

CodePudding user response:

Oraquery1. SQL. Text:='select jh as "pound sign" the from sys. Jhtable';
Try

CodePudding user response:

That's not
If set to UseUnicode:=true; In the retrieval when the search string cannot contain Chinese characters, otherwise couldn't retrieve the results
If set to UseUnicode:=false; Can contain Chinese characters in the search string, but the retrieval results each field only up to 10 characters
Such as: select the from jh daa01 where jh like ' ' ' ' 'ancient %;