UniDac & Unicode (Android) .. Problem !
-
- Posts: 8
- Joined: Mon 03 May 2021 00:09
UniDac & Unicode (Android) .. Problem !
Good Morning.
we use UniDac 8.4.1 in our Co. for work ..
So we test it for
Delphi 10.2.3 Tokyo Firemonkey
Delphi 10.3.3 Rio Firemonkey
Delphi 10.4.2 Sydney Firemonkey
----------
MS SQL 2016
All Fields which have Arabic characters come as questionmarks "??????" ..
Is there a parameter as "Use Unicode" ..
What can I do to solve this issue ..
Thank you so much
Regards .
we use UniDac 8.4.1 in our Co. for work ..
So we test it for
Delphi 10.2.3 Tokyo Firemonkey
Delphi 10.3.3 Rio Firemonkey
Delphi 10.4.2 Sydney Firemonkey
----------
MS SQL 2016
All Fields which have Arabic characters come as questionmarks "??????" ..
Is there a parameter as "Use Unicode" ..
What can I do to solve this issue ..
Thank you so much
Regards .
Last edited by AbdMSultan on Thu 05 Aug 2021 23:04, edited 1 time in total.
-
- Posts: 8
- Joined: Mon 03 May 2021 00:09
Re: UniDac & Unicode (Android) .. Problem !
Delphi 10.2.3 Tokyo Firemonkey
Delphi 10.3.3 Rio Firemonkey
Delphi 10.4.2 Sydney Firemonkey
----------
The problem with unicode texts appears with android applications ..
----------
Thanks
Delphi 10.3.3 Rio Firemonkey
Delphi 10.4.2 Sydney Firemonkey
----------
The problem with unicode texts appears with android applications ..
----------
Thanks
Last edited by AbdMSultan on Thu 05 Aug 2021 23:04, edited 1 time in total.
Re: UniDac & Unicode (Android) .. Problem !
Hi there,
Thanks for provided info.
In order to investigate the issue on our environment, can you please clarify which data type and collation are set for database field?
Regards,
Sergey
Thanks for provided info.
In order to investigate the issue on our environment, can you please clarify which data type and collation are set for database field?
Regards,
Sergey
-
- Posts: 8
- Joined: Mon 03 May 2021 00:09
Re: UniDac & Unicode (Android) .. Problem !
Hi Sergey and Thank you
The Field in MSSQLServer 2016 database :
Data Type : VARCHAR(255)
Collation : Arabic_CI_AI ..
Thanks
The Field in MSSQLServer 2016 database :
Data Type : VARCHAR(255)
Collation : Arabic_CI_AI ..
Thanks
Last edited by AbdMSultan on Thu 05 Aug 2021 23:03, edited 1 time in total.
-
- Posts: 8
- Joined: Mon 03 May 2021 00:09
-
- Posts: 8
- Joined: Mon 03 May 2021 00:09
Re: UniDac & Unicode (Android) .. Problem !
Hello ...
Any suggestions, solutions !!
Any suggestions, solutions !!
Re: UniDac & Unicode (Android) .. Problem !
Thank you for providing the information. We've reproduced the issue and started to investigate possible causes of the described behavior. We will let you know the results as soon as we get them.
-
- Posts: 8
- Joined: Mon 03 May 2021 00:09
Re: UniDac & Unicode (Android) .. Problem !
Thank you so much .. I'm waiting
Regards
Regards
Re: UniDac & Unicode (Android) .. Problem !
Hi there,
Issues with codding may appear on devices where the Arabian language is set, however, you may try converting strings to unicode.
For this you can use DataTypeMapping, this is a special mechanism provided by our components. To set the mapping for a field, you can use the design time editor of the TMSQuery component (or globally in TMSConnection) on the Data type mapping tab you need to add rules:
The type mapping rule can also be set programmatically, for example:
Regards,
Sergey
Issues with codding may appear on devices where the Arabian language is set, however, you may try converting strings to unicode.
For this you can use DataTypeMapping, this is a special mechanism provided by our components. To set the mapping for a field, you can use the design time editor of the TMSQuery component (or globally in TMSConnection) on the Data type mapping tab you need to add rules:
Code: Select all
Database Type = Char
Field Type = WideString
Database Type = Varchar
Field Type = WideString
Database Type = Text
Field Type = WideMemo
Code: Select all
uses
MSDataTypeMap;
...
UniConnection1.DataTypeMap.AddDBTypeRule(msChar, ftWideString, True);
UniConnection1.DataTypeMap.AddDBTypeRule(msVarchar, ftWideString, True);
UniConnection1.DataTypeMap.AddDBTypeRule(msText, ftWideMemo, True);
UniConnection1.Connect;
Sergey
-
- Posts: 8
- Joined: Mon 03 May 2021 00:09
Re: UniDac & Unicode (Android) .. Problem ! (Solved)
Thank you very much, Mr. Sergey
I tried both solutions..the problem is completely resolved
But in the programming method, I wrote in uses
So Thank you so much again ..
Regards .
I tried both solutions..the problem is completely resolved
But in the programming method, I wrote in uses
Code: Select all
uses
MSDataTypeMapUni;
Regards .
Re: UniDac & Unicode (Android) .. Problem !
Hi,
Thank you for your reply! I was happy to assist you!
In case you have any further questions about our products, please feel free to contact us any time!
Regards,
Sergey
Thank you for your reply! I was happy to assist you!
In case you have any further questions about our products, please feel free to contact us any time!
Regards,
Sergey