create database character set AL32UTF8 national charset UTF8

Hello,

I search a script to create database character set AL32UTF8 national charset UTF8.

Thanks

Regards

Bibi
bibi92Asked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
I'm sorry but I am not understanding the actual question.

Yes, you can create a database in the AL32UTF8  characterset:
https://docs.oracle.com/database/122/NLSPG/glossary.htm#NLSPG608

If you want a sample script that actually creates one, again, google around for sample scripts and replace the characterset with AL32UTF8.

There is an example in the online docs that creates a database with AL32UTF8
Examples

Creating a Database: Example

The following statement creates a database and fully specifies each argument:

https://docs.oracle.com/database/122/SQLRF/CREATE-DATABASE.htm#SQLRF01204

CREATE DATABASE sample
   CONTROLFILE REUSE 
   LOGFILE
      GROUP 1 ('diskx:log1.log', 'disky:log1.log') SIZE 50K, 
      GROUP 2 ('diskx:log2.log', 'disky:log2.log') SIZE 50K 
   MAXLOGFILES 5 
   MAXLOGHISTORY 100 
   MAXDATAFILES 10 
   MAXINSTANCES 2 
   ARCHIVELOG 
   CHARACTER SET AL32UTF8
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE  
      'disk1:df1.dbf' AUTOEXTEND ON,
      'disk2:df2.dbf' AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE temp_ts
   UNDO TABLESPACE undo_ts 
   SET TIME_ZONE = '+02:00';

Open in new window

0
 
slightwv (䄆 Netminder) Commented:
The easiest way to get a create database script that you want is to run the  Database Configuration Assistant (DBCA) tool, select all the options you want including the correct character set and at the very end you have the option to save the statements as a script.

https://docs.oracle.com/database/122/ADMIN/creating-and-configuring-an-oracle-database.htm#ADMIN-GUID-99A93810-62B1-4707-9995-89B3D0B5FB56

If you want any old script, google around for samples and change the characterset in whatever script you find.
0
 
bibi92Author Commented:
Ok I know DBCA but I search a script thanks
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
slightwv (䄆 Netminder) Commented:
I do not understand what you are asking.  If you are searching for samples, just google:  oracle create database sample scripts
0
 
bibi92Author Commented:
I search to know if it's possible to create database character set AL32UTF8 national charset UTF8 so having sample script thanks
0
 
bibi92Author Commented:
thanks regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.