November 19, 2009 at 5:29 am
how to implement Unicode ...In a Database i m having a field with nvarchar (max) datatype when inserting a unicode string from the text box in to the database ...it is saving ???????????? in the database .
i am using storeprocedure execution like.......................
exec SP_AH_PRE_REQUEST 'SV',null,1,1,101,'polo',101,10,1,'11/1/2009',1,1,'79789798',101,'11/1/2009',
N'తెలుగుదేసం','fdsdgs'
it is work
but here pass the input parameter @message=N'తెలుగుదేసం'
then only save the correct
then how to pass N'తెలుగుదేసం'
November 19, 2009 at 7:22 am
Is the parameter declared as nvarchar? It should just work if your driver supports it.
Have you tried a straight insert?
November 19, 2009 at 8:01 am
polo.csit (11/19/2009)
how to implement Unicode ...In a Database i m having a field with nvarchar (max) datatype when inserting a unicode string from the text box in to the database ...it is saving ???????????? in the database .i am using storeprocedure execution like.......................
exec SP_AH_PRE_REQUEST 'SV',null,1,1,101,'polo',101,10,1,'11/1/2009',1,1,'79789798',101,'11/1/2009',
N'??????????','fdsdgs'
it is work
but here pass the input parameter @message=N'??????????'
then only save the correct
then how to pass N'??????????'
You need to use text encoding in the application layer and use collation in your column definition and in the query which requires more than your current code. I also think you are encoding Arabic or other right to left language check below for more information on how ot fix that.
http://msdn.microsoft.com/en-us/library/bb330962(SQL.90).aspx
Kind regards,
Gift Peddie
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply