A couple of years ago I did ask my developers to start using the varchar2(char) option when creating new tables. In Norway we have some characters in the alphabet (‘Æ’, ‘Ø’, ‘Å’) that uses more than 1 byte of storage (when the database characterset is set to AL32UTF8). Using the default – varchar2(byte) – could then decrease the number […]
Personal info
My tweets:
Fetch Tweets: Could not authenticate you. Code: 32Java
Oracle
Oracle Blogs
-
Recent Posts
- Use default parameter/setting (row) if not set specific for entity
- SQL Developer, Database Copy and TRUNCATING unwanted tables
- Copy schema with data pump when using editions
- The NUMBER datatype without precision
- Redundant NOT NULLs in DDL
- Java and JDBC for Oracle DBAs – Part 6: Spring-boot, JPA and Hibernate
- PLSQL: Nice little overview of the PL/SQL language
- MacOS: Finally a text editor competing with Notepad++
- Java and JDBC for Oracle DBAs – Part 5: Spring-Boot, JdbcTemplate & DB migration (Using FlywayDB)
- Java and JDBC for Oracle DBAs – Part 4: Your first JDBC Application
Disclaimer
For the avoidance of any doubt, all views expressed here are my own and not those of past or current employers, clients, friends, Oracle Corporation, EVRY, my Mum or, indeed, my mother in law. If you want to sue someone, I suggest you pick on Tigger, but I hope you have a good lawyer. Frankly, I doubt any of the former agree with my views or would want to be associated with them in any way.