Introducing UTF-8 support for Azure SQL Database

Pedro, thanks for the Information.

I'm developing a NET Maui application for Android, using C#, that gets a ChatCompletions response using: chatCompletions.Choices[0].Message.Content from Azure.AI.OpenAI. The documentation says that the response of the ChatCompletions is encoded in UTF-8, so, after I get the response I try to insert it as a string datatype to an Azure SQL Server Database (I'm paying the basic service tier) in a VARCHAR(MAX) column, everything works fine only if I insert a string with a max length of 1,353 characters, If I try to insert a string with a length of more than 1,353 characters I get an error message from the server.

This is the error message:

• A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 35 - An internal exception was caught)

And this is the inner exception:

• Unable to read data from the transport connection: Connection reset by peer.

I tried to insert the string with more than 1,353 characters, using the UTF-8 encoding, directly to the table using SQL Server Management Studio and it worked with no problem at all, so, the error only happens when I try to insert the string with more than 1,353 characters and when I try to do it from the Net Maui Application. I don't think there is a problem with my application because the insert operation works fine when the string has less than 1,353 characters. Do you know if is there any kind of restriction in the SQL Server Azure Database when trying to insert larger amounts of data as string in a VARCHAR(MAX) column or something?