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'.
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire