Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gk_sezhian
Starting Member
1 Post |
 Posted - 2007-04-17 : 06:51:58
|
| The execute function is not taking the arabic chars in..or nvarchars inwhat i did is execute(@sql)where @sql is a nvarchar Assuming it as a insert statement to a table the chars are appearing as ????where as the chars when inserted using a plain insert query comes clearly in arabic set @sql=insert into test values('arabic chars');insert into test values('arabic chars'); works good plainlybut when called through execute it flopsexecute (@sql)I even tried by inserting the @sql value to the DB it is coming in arabic.i tried using this but syntax error occuredEXECUTE sp_executesql @stmt =N' (@sqls)', @Farms = N'@sqls nvarchar(max)', @sqls = @strintest The above is working only when we give the query with dynmic values to be passed in |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-17 : 07:38:45
|
"set @sql=insert into test values('arabic chars');"is that just a typo posting here, or is that what you used?You would need:set @sql= 'insert into test values(''[/b]arabic chars''[/b]);'[/b]Kristen |
 |
|
|
|
|
|
Issues with execute function