Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
khchoy
Partner - Creator
Partner - Creator

What is BINARY data type of Oracle Source Endpoint in User Guide ?

Hi,

In Qlik Replicate User Guide and Online Help, Oracle source endpoint supported data types include "BINARY".

What is "BINARY" ? I checked several versions , all included. So I checked Oracle manual in Oracle site, I can't find "BINARY" data type. Is it wrong information ? if it is mistake , why it is not fixed ?

Regards,

KwangHobinary.png

 

Labels (1)
6 Replies
ltf
Employee
Employee

Hi @khchoy,

Thank you for contacting us through Qlik community.


The Oracle database for Qlik Replicate supports most Oracle data types, in which BINARY is one of them using Qlik Replicate and the default mapping to Qlik Replicate data types. Qlik Replicate converts source data to its own data type. For data that Replicate cannot convert, it returns an error.


For example, when replicating data from an Oracle source endpoint to a Microsoft SQL Server target endpoint, Replicate first converts the Oracle data type BINARY to the Replicate data type BYTES. BYTES maps to the Microsoft SQL Server data type VARBINARY (Length)


More info: https://help.qlik.com/en-US/replicate/November2023/Content/Replicate/Main/Endpoints/att_rep_data_typ...


Let us know if you have any further questions.

Best Regards,
Faariha

Yadunandan
Support
Support

Hello KwangHo,

The BINARY type is similar to CHAR, except that they store binary strings rather than nonbinary strings. That is, they store byte strings rather than character strings. This means they have the BINARY character set and collation, and comparison and sorting are based on the numeric values of the bytes in the values.

You can refer to BINARY DATATYPE for more information.

Regards,
Yadunandan

khchoy
Partner - Creator
Partner - Creator
Author

Is "BINARY" data type built in Oracle Data type ?  BINARY DATATYPE link is MySQL Manual.

I can't find "BINARY" data type in Oracle database. In Replicate User  Guide and Help , Oracle database  have "BINARY" data type. But I think "BINARY" data type is Oracle MySQL datatype.

(Ref: ChatGPT answer : Oracle does not have a built-in "BINARY" data type. However, Oracle does have data types like BLOB (Binary Large Object) and RAW which can be used to store binary data. )

binary.png

Heinvandenheuvel
Specialist III
Specialist III

This does look like a mistake. 

The intended is to talk about chars which are not interpreted according to some NLS rules, but what is te point if the datatype does not actually exist and thus cannot be 'detected' by Replicate.

khchoy
Partner - Creator
Partner - Creator
Author

I think some mistake in Manual must fixed next version. 

DesmondWOO
Support
Support

Hi @khchoy ,

Agree with @Heinvandenheuvel , I can't find BINARY data type in the Oracle Built-In Data Type Summary.

Please create a support ticket for this issue.

Thanks,
Desmond

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!