How to Edit & Read binary data on SQL 2005
-
My friends & I have a problem with our one of the table of our SQL Data... One of our Table Column shows like this when we view it in sql : ChaInvent We dont know how to read & edit inside that CharInvent..?? That ChaInvent has all the information we need because that is place where are all the Inventory on the Game of the Character stored like weapons, armors, potion, ..etc..haysss..Any Help here? Are there any script or program that can read & interpret those data readable by Human?? I tried to search all the Info here but NO LUCK...
-
My friends & I have a problem with our one of the table of our SQL Data... One of our Table Column shows like this when we view it in sql : ChaInvent We dont know how to read & edit inside that CharInvent..?? That ChaInvent has all the information we need because that is place where are all the Inventory on the Game of the Character stored like weapons, armors, potion, ..etc..haysss..Any Help here? Are there any script or program that can read & interpret those data readable by Human?? I tried to search all the Info here but NO LUCK...
you always get binary data when running a select. It depends on the client how to process it, mostly it becomes a array of bytes. You can show it by storing it to file or convert it to strings to show it in a memo or listbox. You probably used the sql studio manager for viewing data, this is not showing you binary data. greetz kurt
-
you always get binary data when running a select. It depends on the client how to process it, mostly it becomes a array of bytes. You can show it by storing it to file or convert it to strings to show it in a memo or listbox. You probably used the sql studio manager for viewing data, this is not showing you binary data. greetz kurt
-
...."You can show it by storing it to file or convert it to strings to show it in a memo or listbox"... How?? we don't know, Please Help us...
Or you can write a program in you're language. for example C# or build a query like this..
EXEC master.dbo.sp\_configure 'show advanced options',1 RECONFIGURE EXEC master.dbo.sp\_configure 'xp\_cmdshell', 1 RECONFIGURE declare @query varchar(500) set @query = 'BCP "SELECT \* FROM YourTable" queryout "C:\\YourTable.txt" -c -T -C850 -S(local)\\SQLEXPRESS -Usa -Psa' EXEC master..xp\_cmdshell @query EXEC master.dbo.sp\_configure 'xp\_cmdshell', 0 RECONFIGURE EXEC master.dbo.sp\_configure 'show advanced options', 0 RECONFIGUREBe sure you're sql server has rights to write on the HD. (set local system account of you're SQL service) greetz Kurt