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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy