Monday 15 September 2014

sql server - Convert varchar special characters to nvarchar with trigger -


Whenever any data is entered, I need to create a trigger to put in another table.

  create a trigger [site]. [Website] on [site]. [Customer] After INSERT, start as Update; DECLARE @Customerid int, @name nvarchar @ Select the Empiry date @Customer = subscriber, @expression = expiration, @names = Notified by name update [DBO]. [Customer] SET [expiredate] = @Experian, [name] = @name where [id] = @Get subscriber end  

But, [site] column [name] on [site]. [Customer] is varchar, and on the column [name] [dbo]. [Customers] is nvarchar and I have data like "neo pound" on the "vergard" column, and i need to change the real presentation of the novel, which is "nine arka"

I have already convert and convert (nvarchar, [name]) but it gives me unicode for every "ugly" character

I do not have more Thoughts, is it possible ??

Thanks


No comments:

Post a Comment