Print Thread
Unicode and DOA, how to set DOA Properties, that it works?
#56054 03/06/17 08:36 AM
Joined: Jul 2015
Posts: 5
M
Member
OP Offline
Member
M
Joined: Jul 2015
Posts: 5
I Have an DB with AL32UTF8 Charset.
All Tables with varchar2, length set with char.
Delphi XE3 with DOA 4.1.3.5

TOracleSession set
BytesPerCharacter to bcAutoDetect
Preferences.ConvertUTF to cuUTF8TOUTF16
Preferences.ForceWideStringField to true

If I set Fields to Dataset the tfield.size are 4*charsize,
but it is wrong, Field.Size are Chars not Byte.

Then I get the hole Data from the field, but the tbdedit length too large, i can insert more chars than the db can insert.

If I set OracleDictionary.CharterSize=true, then the Tfield.Size right.
Then I get too small data from the db if data has 2Byte Chars like

Re: Unicode and DOA, how to set DOA Properties, that it works?
mschroeer #56343 04/13/17 07:11 AM
Joined: Jul 2015
Posts: 5
M
Member
OP Offline
Member
M
Joined: Jul 2015
Posts: 5
Hello,

can nobody explain how unicode works with doa?
Which property must i set in doa and which parameter must i set in
the database, that it all works fine?

Re: Unicode and DOA, how to set DOA Properties, that it works?
mschroeer #60197 06/18/19 02:47 PM
Joined: Apr 2013
Posts: 6
F
Member
Offline
Member
F
Joined: Apr 2013
Posts: 6
Dear Marco,

We have the same problem. Do You have any solution?

regards
Sandor


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.088s Queries: 14 (0.014s) Memory: 2.5007 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-05 06:32:51 UTC
Valid HTML 5 and Valid CSS