Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utf8 at column level - table def.

spanish_inquisitionSep 4 2015 — edited Sep 9 2015

Hi Experts;

I would like to ask you about setting up charset at table level to suport non-latin chars

Let us say at db level we do have charset  WE8ISO8859P1 or WE8ISO8859P15  and we want to have table in which we will have Japanese chars.

I found under the following link:

https://docs.oracle.com/cd/E17952_01/refman-5.1-en/alter-table.html

info that it should work in a way:

CREATE TABLE t1

(

    col1 nvarchar2(10) CHARACTER SET utf8

);

but it doesn't in 12.1.0.1 Oracle Enterprise 64 bit.

Can you provide a view on that? I do not want to change charset at database level.

Regards,

Bolo

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2015
Added on Sep 4 2015
11 comments
3,529 views