May 22, 2012 at 5:08 am
A co-worker is telling me that there is a square character in the field of most records in a table she has. She said that this means the data is encrypted. Is this true? I cannot find this verified anywhere.
May 22, 2012 at 5:14 am
not nessesarily, it could just be a invalid char to which there is no local code page varient for and it displays a box to show you something is there. i commonly see this when people store special characters in varchar columns instead of nvarchar columns
May 22, 2012 at 5:33 am
if it's in an nvarchar column then soembody forgot to put the N' identifier in the insert statement and you have non-ascii characters stored in your string in unusable format
MVDBA
May 22, 2012 at 5:37 am
Hi Mike,
The column is (varchar(20), not null). I do not recall ever seeing a square character in a data field. So I could not dispute that this means encrypted. Thanks for the information.
Charlie
May 22, 2012 at 6:05 am
try this and see if it matches
create table #temp (mydata varchar(20))
insert into #temp select 'ABCDEF?/??GHIJK'
select * from #temp
drop table #temp
MVDBA
May 22, 2012 at 6:15 am
Hi Michael,
I did as you suggested. The data field in the table reflects "ABCDEF?/??GHIJK".
Charlie
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply