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.
| Author |
Topic |
|
IR-Bastian
Starting Member
3 Posts |
 Posted - 2007-05-21 : 06:02:45
|
| Hi folks,i have a problem with the result of my query. There is a colum(a stored BLOB) witch appears like this:8t¦–XEÄð_JÑ |e�ØÊ/TÅ® 0ù¯ó£1XðíðpŸ8ãÖð'1ª@ˆ8^j÷§K§ì©P=@Ÿú‡¿`T)áGä^ÄÞ˜ÖPfìrç(GC=8»ç?‹T¼²¤÷ôœ1Ogu… JK £JÝ8n1+CD"¹¯ÖE°-§¡�0(Ä¡‡6K? =L: Dþfþ¿€s¬ ð0ÀçPä]C·Y1ÄÅ¿(ßû‡Tâg@T $û?äþ0¯R@¥8NTÄhÄ “œã17D?iI have a progam(QMF for Windows) in which i can selcet the colum and can chose bettween hexadezimal and binary. Now my question: How can i make it works, that it is displayed as hexadezimal directly? An what is that above?Many thanks in advance! |
|
|
IR-Bastian
Starting Member
3 Posts |
Posted - 2007-05-21 : 07:12:12
|
| PS: I am looking for something like the RAWTOHEX Funktion, but i need it fpr a Teradata database! |
 |
|
|
IR-Bastian
Starting Member
3 Posts |
Posted - 2007-05-21 : 09:49:14
|
| Solved:SELECT HEX(coloumname) from table |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Why does the BLOB looks corupted?