Sql server changes varbinary to fix-length 
Author Message
 Sql server changes varbinary to fix-length
I am using 6.5. I want to know under what circumstances, sql server
chages the table definition from varbinary to fixed-length. I am
creating new table by using select into transact statement. In the old
table, the column is defined as varbinary but the new table changes it
to fixed-length and gets padded by zeros at the end.


Sat, 22 May 2004 03:51:38 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Varbinary column is changing to fixed-length Why?

2. LONG VARBINARY length in embedded SQL - System XI

3. SQL Server varchar returns fixed length ?

4. BCP OUT Fixed-Length Record: Truncated Length

5. ADOX: Extending a fixed length Jet string field length

6. Importing a fixed fieldwidth, fixed row length file

7. Question on bulk loading of fixed length/fixed field records

8. Changing a field length in SQL Server

9. Importing fixed length ASCII into SQL? long answer

10. Creating Fixed-Record Length Text File - PL/SQL Command File

11. Converting varbinary in Shiloh (SQL Server 2000 Beta 2)


 
Powered by phpBB® Forum Software