How to find workaround for xml.value() function in babelfish?

1

We encountered an xml issue during the poc of babelfish migration, how to rewrite a user define function based on 64-bit encryption that is very common in sql server. The following code you can find on many web site

CREATE FUNCTION [dbo].[FnBase64Encode](@src varchar(max))
  RETURNS VARCHAR(max)
as
begin
  declare @bin varbinary(max)
  set @bin=Convert(varbinary(max), @src)
  return cast(N'' as xml).value('xs:base64Binary(xs:hexBinary(sql:variable("@bin")))', 'varchar(max)')
end
GO

We know that the current version of babelfish(1.2.1) does not support xml methods such as xml.node and xml.value, is there any solution or sample code for this case?

1개 답변
0
수락된 답변

Hi, @Colin Tang.

As you understand, the XML feature of T-SQL is not supported in Babelfish 1.2.1 as of today.

If you want to do XML operations like this, you need to connect to the Aurora PostgreSQL port and consider whether you can use PostgreSQL's XML Functions instead.

profile picture
전문가
iwasa
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠