How to find workaround for xml.value() function in babelfish?
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?
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.
How to find workaround for xml.value() function in babelfish?Accepted Answerasked 2 months ago
What port does Babelfish work over and should I be able to test with osql?asked a year ago
How do I move an Entity Framework or EF Core app with Babelfish?
Babelfish and the SQLSRV driver in PHP
What are the limitations of Babelfish?
How to assign a lambda function alias to LexV2asked 5 months ago
Babelfish backup and recovery options
Does Babelfish support XML? How can I use XML?
Babelfish: How do I get started?
Tag request for Babelfish