GetSchema error when schema have some Chinese characters and length is odd

Data Abstract
,
1

DA Server 9.2.101.1295
DAD:Delphi 10.2 Tokyo.

When schema have some Chinese characters and length is odd,on GetSchema get exception‘Cannotload XML document.Reason:…’.
but when length is even,Getschema is no problem.
correctly schema
<Name>会员号</Name>
Get schema
<Name>会员�?/Name>
in the version 9.0.97.1245 are correct.
in the varsion 9.2.101.1295 are incorrect.

2

can you create a simple testcase that demonstrates this problem, pls?

it works for me correctly:

can you retest this issue with the latest beta too, pls?

3

a simple testcase:VCLApplication.rar (117.4 KB)

schema:

1.jpg852×420 41.7 KB

when preview table,will get a error:

4.jpg851×587 52.7 KB

Open DataService_impl,Retriveve datatable schema for DAmemdatatable1,have a error:

on Client will get same error.

but when Change schema table sql to:

select ‘0001’ as 会员,111 as 积分
union all
select ‘0002’ as 会员,222 as 积分

GetSchema is correctly.

4

I can reproduce problem with preview inside Schema modeler only and can’t with LDA

can you retest LDA issue with latest beta build, pls?

5

Thanks, logged as bugs://78007

6

On Chinese windows 7 pro ,The problem still exists with latest beta build。
I try test demo in english windows 7 pro , Retriveve datatable schema with LDA is no problem.
So,Maybe it has something with the OS language？

7

hmm, probably I do something wrong, but it works for me, even sql is

select '0001' as 会员号,111 as 积分

animation.gif1312×652 628 KB

8

On Chinese windows 7 pro ,The problem still exists with latest beta build。
I try test demo in english windows 7 pro , Retriveve datatable schema with LDA is no problem.
So,Maybe it has something with the OS language？

9

at opening table, if fields are empty, table schema is read before reading of data.
so in your case it can be like

table.Fields.Clear;
table.Open;

it can be a workaround for LDA case.

10

But LDA and RDA still can not work at LoadSchema on Chinese windows 7 pro.
How Can fix this issue?

11

I haven’t Chinese Windows 7.

can you perform additional tests with your english windows 7 pro like:

12

1、English windows 7,set Chinese as default language for non-unicode program, issue will be reproduced.
2、Chinese windows 7,set English(United States) as Default language for non-unicode programs,issue can not reproduce.

language for non-unicode programs setting change the default codepage for unicode, the string type encode and decode dependent of default codepage. but utf8string independent of default codepage.

13

Thanks, logged as bugs://78026

14

bugs://78026 got closed with status fixed.

15

fix will be in next week’s beta

16

bugs://78007 got closed with status fixed.