korntex5
User
Junior Boarder
| Posts: 11 |   |
Karma: 0
|
|
Re:why i have #0 between all my carracters
|
|
Posted: 2007/09/04 05:17 |
|
|
|
|
1) of course the text 'TOTO' is correct in table
2) NLS_CHARACTERSET=UTF8
and
NLS_NCHAR_CHARACTERSET= UTF8
3) my oracle is 9
i try to pass the problem with :
CurMess:='';
s := ADQ.FieldByName('MESSAGE').AsString;
for i := 1 to Length(s) do
if s[i] <> #0 then
CurMess := CurMess + s[i];
|
but the Curmess variable contains after all only the first part of the real clob, becose the length delphi's function doesn't count the #0
I'm turning around, thank you for your interest.
Post edited by: korntex5, at: 2007/09/04 05:17
Post edited by: korntex5, at: 2007/09/04 05:18
Post edited by: korntex5, at: 2007/09/04 05:19
Post edited by: korntex5, at: 2007/09/04 05:20
|
|
in NCOCI8, the astring function on my clob work perfectly without #0