Unicode support in TOracleDirectPathLoader

[MIke DBSL]

Hello

Does TOracleDirectPathLoader support Unicode?
Also what about array inserts? Do they work correctly with Unicode?

Mike

 

[Marco Kalter]

Yes, both support Unicode. Do you have a specific problem?

 

[MIke DBSL]

Does TOracleDirectPathLoader support Unicode?

I have cheked the documentaion and examples and there is nothing about the support for unicode.

I am after an working example

I have a table with one field nvarchar2(2000)
How do I load the data into my table from an ut8 or utf16 file?

Mike

 

[MIke DBSL]

Array inserts.

Situation
Source file is unicode and has only 6 lines
all the lines have the data

table has only one field

after array insert it looks like this
1 field is fine
2 field is null
3 field first charatcer is missing
4 field is null
5 field first charatcer is missing
6 field is null

I can build an simple example and email it you if you want

Mike

 

[MIke DBSL]

// In case of an UTF16 variable, the length needs to be returned and set
if IsUTF16CharSet(CharSetID) then
begin
lp := @len;
lBufType := otVarchar2;
end;

I believe lp should be be an array not a single variable.

alenp (IN/OUT)

Pointer to array of actual lengths of array elements. Each element in alenp is the length (in bytes, unless the data in valuep is in Unicode, when it is in codepoints) of the data in the corresponding element in the bind value array before and after the execute. This parameter is ignored for dynamic binds.
Note:

If alenp is less than value_sz, data will be skipped.

I there any chance to get any support here and not endless silence?