I want my Oracle database to properly store ALL possible UTF8 characters. If NLS_CHARSET is set to AL32UTF8 is that all I need to do? Or do I need to also make sure I use NCHAR and NVARCHAR rather than CHAR and VARCHAR to properly store UTf8 characters?
Good question. I'll give a simplified answer.
Oracle supports two character sets simultaneously, by way of different datatypes and parameters. A "normal" database-wide characterset and a "national" characterset.
Now, the "normal" characterset affects the way that
These are dictated at database creation time. For example:
You can see these by checking in your DB. For example:
If your normal characterset is UTF%, you're generally safe staying away from the