Equivalent data type for an Oracle varchar2(byte) in T-SQL

Question

Equivalent data type for an Oracle varchar2(byte) in T-SQL

pmscorca 1,052

Hi, I need reading and writing Oracle data having the varchar2(byte) as a data type by using the corresponding data type in T-SQL (SQL Server and Synapse). Which is the equivalent data type in T-SQL for an Oracle varchar2(byte)? Thanks

Accepted answer

1 additional answer

Your answer

Answer 1

Hi @pmscorca Below are summary tables show how Character and binary string datatypes translated from Oracle to SQL Server.

User's image Referring from this article: Datatypes translation between Oracle and SQL Server part 1: character, binary strings.

Best regards,

Cosmog Hong

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Olaf Helper 47,436

See article https://learn.microsoft.com/en-us/sql/relational-databases/replication/non-sql/data-type-mapping-for-oracle-publishers?view=sql-server-ver16

pmscorca 1,052 Reputation points

2024-02-07T14:54:12.3533333+00:00

Hi, thanks for your suggest. I've already read the article, but it doesn't talk about the varchar2(n byte) data type of Oracle. I'm referring to varchar2(n byte) data type and not varchar2(n char) one.
Olaf Helper 47,436 Reputation points

2024-02-07T19:26:13.99+00:00

There is no really equivalent; varchar2(byte) is UTF-8 with variable bytes- Closest is NVARCHAR(n).see https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16

Share via

Equivalent data type for an Oracle varchar2(byte) in T-SQL

1 additional answer

Your answer