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

Thread: change character set while importing

  1. #1
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322

    change character set while importing

    How can I change the character set while importing as I have a customer schema in Japanese character set? I see the following warning.


    import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
    export client uses JA16SJISTILDE character set (possible charset conversion)


    Alternatively, I created a new database with JA16SJISTILDE character set but still I see the same warning. The problem is that probably because of no conversion of character set, some unique indexes do not get created gvivng the message "cannot CREATE UNIQUE INDEX; duplicate keys found". When I check the table rows for indexed columns, it shows some rows that look same in present character set. I think if I am able to eliminate the character set problem, I will be able to create unique indexes.
    lucky

  2. #2
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    I am so sorry. I am able to get it working. I was specifying the wrong service name after creating new database in JA16SJISTILDE character set and while doing import.

    I think NLS_LANG is the other way to get it working.
    lucky

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