mORMot Open Source

luscen

Member

Registered: 2014-04-21

Posts: 8

hello,AB, Can i definition the SQLRecord Field （RawUTF8）by chinese?

eg.
TSQLTouZiZH = class(TSQLRecord)
    private
        F账号: RawUTF8;             //账号
        F账户名: RawUTF8;           //账户名
        F开户日期: TDateTime;       //开户日期

    published
        property 账号: RawUTF8 index 20 read F账号 write F账号;
        property 账户名: RawUTF8 index 10 read F账户名 write F账户名;
        property 开户日期: TDateTime read F开户日期 write F开户日期;

    end;

by this way, the ORM's CreateAndFillPrepare function is not work. the code is :
    ent: TSQLTouZiZH;
    ent := TSQLTouZiZH.CreateAndFillPrepare(aClient,'*');
I step into the function:
    aTable := aClient.MultiFieldValues(RecordClass,aCustomFieldsCSV,aSQLWhere);
that the aTable is nil.
How I do for this ? think you!

luscen

Member

Registered: 2014-04-21

Posts: 8

Re: hello,AB, Can i definition the SQLRecord Field （RawUTF8）by chinese?

My Compiler is Delphi 10.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,266

Website

Re: hello,AB, Can i definition the SQLRecord Field （RawUTF8）by chinese?

No, internally we expect 7 bit ascii field names, e.g. A-Z,a-z,0-9 and _.

luscen

Member

Registered: 2014-04-21

Posts: 8

Re: hello,AB, Can i definition the SQLRecord Field （RawUTF8）by chinese?

all right, I understand.thank you AB.