Tab Key - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Tab Key

Author

Topic

sanjay5219
Posting Yak Master

240 Posts

Posted - 2012-05-04 : 12:42:31

Hi All,

I am struggling with TAB key value "BOX SHAPE" in my SQL Server. I have tried replacing with char(13) but is does not work and the problem is when i am generating raw data in notepad it gives me everywhere that box

Please suggest

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-05-04 : 15:47:31

It may be that they are not tabs at all. You can cast the column to varbinary and look at the ascii code to see what the character(s) are.

SELECT ColA,CAST(colA AS VARBINARY) FROM YourTable

It could also be that the data in the table has some other collation. Japanese, Chinese etc. perhaps? You can see if it has any unexpected collations using this:

SELECT name,collation_name FROM sys.columns WHERE OBJECT_NAME(OBJECT_ID) = 'YourTable'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources