-
DB Character set UTF8
hi ,
How to create DB with UTF8 charcater set ? sysntax please
When i try to create database like these iam geting these error
CREATE DATABASE "EMAGIA"
DATAFILE
'/oracle/apps/oracle/admin/NEW/system01.dbf' size 200m
logfile
group 1
'/oracle/apps/oracle/admin/NEW/log1.log' size 100m,
group 2
'/oracle/apps/oracle/admin/NEW/log2.log' size 100m
undo tablespace UNDOTBS1 datafile '/oracle/apps/oracle/admin/NEW/undo.dbf' size 150m
charcater set UTF8 NATIONAL character set UTF8;
Iam geting error
even i try to create db by setting NLS_LANG value in .profile file also like these
NLS_LANG=AMERICAN_AMERICA.UTF8
akram shaik .
-
Instead of charcater - try character!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|