Hi,

This function have error in some words.

Example:

But this result is meaningless

I don't know why this error.

Kindly help me resolve it. Tks.

Hi Jeffrey Williams,

Almost case, replace function replace done but in some case do not fail.

Function:

ALTER Function [dbo].[test_uni_vni_replace] (

@string nvarchar(max)

)

Returns nvarchar(max)

As

Begin

Select @string = replace(@string collate Latin1_General_CS_AS, viet, vni)

From dbo.viet_character_encoding;

Return @string;

End

Example:

declare @input...

Dear Phil Parkin,

I'm Vietnamese. In Vietnamese language using 2 tpye: unicode encoding and VNI encoding. This function used for convert from Unicode to VNI.

Example: Unicode: "Lê Minh Trung" ->> VNI:...

Dear scdecade,

Your function can not use in my database, my database running on SQL server 2014 and can not support JSON.

Pls help me fix it.

Thank you.