Special datatype considerations  Precision and scale with number datatypes

Chapter 3: Reference Topics for Oracle

Padding raw(n)

Oracle pads raw(n) datatypes with blanks when users insert values less than n. SQL Server pads binary(n) datatypes with 0s when users insert values less than n.

An error may occur if an Adaptive Server Enterprise user expects 0-padded data yet accesses blank-padded data. Likewise, there may be problems if native Oracle applications expect to see blank-padded data, yet access 0-padded data.





Copyright © 2005. Sybase Inc. All rights reserved. Precision and scale with number datatypes

View this book as PDF