mardi 9 décembre 2008

Insert unicode into Sql Server Database

Today, I meet an issue while trying to store unicode text in an Sql Server 2005 database. The objective was to store hungarian character.

I was thinking that NVARCHAR field will do the job but it wasn't so simple ... I had to change alll my query :

INSERT INTO TABLE1 VALUES ('Szerződés száma') --> Don't work
INSERT INTO TABLE1 VALUES (N'Szerződés száma') --> Work

You have to prefix all your string value by 'N'.

Aucun commentaire: