Running Stored Procedure with non English parameter values
40 views
Skip to first unread message
Agis Kefalinos
Jan 15, 2016, 11:00:58 AM1/15/16
to tedious
Hello I am running a stored procedure call and one of the parameter has Greek text. The problem is that the Greek are not saved correctly. The collation of DB is GREEK_CI_AI
I am giving the value "Αγις Κεφαλινος" and it is saved as "‘³¹Â šµÆ±»¹½¿Â" .
I am giving the value "Αγις Κεφαλινος" and it is saved as "‘³¹Â šµÆ±»¹½¿Â" .
Agis Kefalinos
Jan 16, 2016, 6:38:24 PM1/16/16
to tedious
Well, it seems that was a noobish mistake of mine. I have to pass the parameter as NvarChar in order to work.
Reply all
Reply to author
Forward
0 new messages