Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[Table_1]([ID] INTEGER NOT NULL, [BIN] [binary](20) NULL);
- INSERT INTO table_1 values (1, cast('I am a binary field' as BINARY));
- SELECT ID, BIN, CAST(BIN AS VARCHAR(20)) AS BINTEXT FROM TABLE_1;
- ID BIN BINTEXT
- ----------- ------------------------------------------ --------------------
- 1 0x4920616D20612062696E617279206669656C6400 I am a binary field
Add Comment
Please, Sign In to add comment