Encryption - Decryption with French Words in SQl Server 2008

See more:

SQL

encryption

i want to add French word like 'Catégories' in my table with EncryptByKey. Here is my query.

OPEN SYMMETRIC KEY SymmetricKey1 DECRYPTION BY CERTIFICATE Certificate1; insert into tbl_Name (Name) values (EncryptByKey( Key_GUID('SymmetricKey1'), CONVERT(Nvarchar,'Catégories')))

but when i retrieve the value with following query, i got 慃㽴潧楲獥 instead of Catégories

OPEN SYMMETRIC KEY SymmetricKey1 DECRYPTION BY CERTIFICATE Certificate1; SELECt CONVERT(NVARCHAR(max),DECRYPTBYKEY(Name)) as Name from tbl_Name

can you plz give me help for this?