Difference between BYTE and CHAR in column datatypes

by

Let us assume the database character set is UTF-8, which is the recommended setting in recent versions of Oracle. In this case, some characters take more than 1 byte to store in the database.

If you define the field as VARCHAR2(11 BYTE), Oracle can use up to 11 bytes for storage, but you may not actually be able to store 11 characters in the field, because some of them take more than one byte to store, e.g. non-English characters.

By defining the field as VARCHAR2(11 CHAR) you tell Oracle it can use enough space to store 11 characters, no matter how many bytes it takes to store each one. A single character may require up to 4 bytes.

More Related Contents:

  1. Finding rows that don’t contain numeric data in Oracle
  2. SQL Query output in VBA is different than in SQL Oracle
  3. I want to find out how much zero come after 1 in SQL
  4. Update statement with inner join on Oracle
  5. Splitting string into multiple rows in Oracle
  6. Is there any function in oracle similar to group_concat in mysql? [duplicate]
  7. How to use the ‘as’ keyword to alias a table in Oracle?
  8. What is the string concatenation operator in Oracle?
  9. Using an Alias in a WHERE clause
  10. How can I introduce multiple conditions in LIKE operator?
  11. Is there any boolean type in Oracle databases?
  12. Stored Procedure with optional “WHERE” parameters
  13. How to Select a substring in Oracle SQL up to a specific character?
  14. passing table and column name dynamically using bind variables
  15. Conditional SUM on Oracle
  16. How to get second largest or third largest entry from a table [duplicate]
  17. ORA 00904 Error:Invalid Identifier
  18. Deferrable Constraints in SQL Server
  19. Nth max salary in Oracle
  20. What does the colon sign “:” do in a SQL query?
  21. How do I get textual contents from BLOB in Oracle SQL
  22. SQL not displaying null values on a not equals query?
  23. What can cause an Oracle ROWID to change?
  24. Oracle query to match all values in the list among all rows in table
  25. Inserting into Oracle and retrieving the generated sequence ID
  26. Return number from Oracle Select statement after parsing date
  27. How do you interpret a query’s explain plan?
  28. Oracle DB: How can I write query ignoring case?
  29. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  30. Oracle Convert TIMESTAMP with Timezone to DATE

Leave a Comment