sql server - special character not visible in the database -


there special character in 1 of data field. need know it. know it's not space.

the select query returns akasa , akasa. there 2 same entries on defined primary column.

select userid users userid 'akasa%'. 

when use len function in query showing length 5 , 7. means these different values.

when use command

select userid users userid='akasa  '. 

it doesn't show means not space.

so, realized there 2 special characters not visible , need know ? can use detect them ?

i first ask why want know is. if intent rid of or turn else, row can selected with:

... userid 'akasa%' , userid <> 'akasa' 

for example, delete it, use delete clause.

alternatively, if do need know are, write little java/jdbc or c#/odbc program retrieve row using where clause , should able print out real column value in form want, such hex representation.


Comments

Popular posts from this blog

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

html - How to style widget with post count different than without post count -

url rewriting - How to redirect a http POST with urlrewritefilter -