Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Unicode problem

2 Posts 2 Posters 0 Views 1 Watching

W Offline
W Offline
WDI

wrote on last edited by

#1

Hi This is part of a sp to search on db. set @sql = @sql + N' and (summary like ''%' + @keywords + '%'')' but it doesnt find unicode cells of table. what should i do ?
M 1 Reply Last reply

0
W WDI

Hi This is part of a sp to search on db. set @sql = @sql + N' and (summary like ''%' + @keywords + '%'')' but it doesnt find unicode cells of table. what should i do ?
M Offline
M Offline
Mattias Olgerfelt

wrote on last edited by

#2

Dont't use concated SQL... for this. Create a procedure and just add the value as paramter.. Also.. beaware of the collation... /M
1 Reply Last reply

0

Log in to reply