uniLoader posting Chinese chars

[arusoft]

I was testing uniLoder to post data from SQL Server to access database for backup purpose. Everything is looking fine till now. But I am seeing Chinese chars in access fields where data type is MEMO.

Please advice.

Thank You.

[AlexP]

Hello,

There is no Memo field in MS SQL Server. Please clarify the field type in the table.

[arusoft]

Sorry if I was not clear.
We are posting data from SQL Server to Access.
SQL Server had datatype of varchar(4000). Access has data type of Memo.

Please let me know if you need more clarification.

Thank You.

[AlexP]

Please provide a sample of data stored in this field on SQL Server, data inserted to MS Access, as well as a sample of code you are using for data copying.

[arusoft]

I am working on creating sample code for you. But meanwhile can you please advice what would be your suggested way to backup/restore tables in both SQL & Oracle database.

[AlexP]

For full backup we recommend to use standard means of the servers.

[arusoft]

Its not full backup. Only selected tables are backed up. please advice in this case. Thank You.

[arusoft]

I am not able post attachment. I am not seeing any option on this page.

But here is what I am doing.

1. Create table in Oracle
create table TestTable
(Field1 varchar2(4000) )

Insert values in TestTable
Insert into TestTable values ('TestTable values ')

2. Create a table called TestTable in ACCESS database(Test.mdb)
Have one field called Field1 of type MEMO.

3. Have access database Test.mdb in same directory as application

4.Here is my Delphi code that has two Uniconnection component(One for Oracele and other for ACCESS.), a uniQuery & a uniLoader component.

procedure TForm1.Button1Click(Sender: TObject);
begin
UniConnection1.ProviderName := 'ORACLE';
UniConnection1.Server := 'SERVER_NAME';
UniConnection1.Username := 'Username';
UniConnection1.Password := 'Password';
UniConnection1.LoginPrompt := False;
UniConnection1.Connected := True;

UniQuery1.SQL.Text := 'select * from TestTable';
UniQuery1.Connection := UniConnection1;
UniQuery1.Active := True;

UniConnection2.ProviderName := 'access';
UniConnection2.Database := ExtractFilePath(Application.ExeName)+ 'Test.mdb';
UniConnection2.LoginPrompt := False;
UniConnection2.Connected := True;

UniLoader1.Connection := UniConnection2;
UniLoader1.TableName := 'TestTable';
UniLoader1.LoadFromDataSet(UniQuery1);
end;


You will now chines chars in field1 敔瑳慔汢⁥慶畬獥


If I go ahead and add another field in both Oracle & Access ( Oracle datatype as varchar2(20) and access as Text(20)) and I repeat my test, I will see Chines chars in field1 and proper value in field2.

Please advice.

Thank You.

[AlexP]

We have reproduced the second problem and will investigate the reasons for such behavior.

[arusoft]

Alex any update on this? Will appreciate any feedback.

Thank You.

[AlexP]

We will fix the problem till the next release

[arusoft]

Hi Alex,

Is this fixed with 5.3?

Thank You.

[arusoft]

Alex,

Any update on this please? Is this fixed with 5.3?

Thank You.

[AlexP]

We have fixed the problem, however, this fix wasn't included to the current version. We can send you a night build including this fix.

[arusoft]

Thanks Alex. I would really Appreciate that.

Regards.