DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DB Character set UTF8

  1. #1
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145

    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 .

  2. #2
    Join Date
    May 2003
    Posts
    2
    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
  •  


Click Here to Expand Forum to Full Width