Re: table design for Globalization in Oracle ERP
Date: Tue, 25 Aug 2009 06:30:30 -0700 (PDT)
Message-ID: <2a5637ed-0993-4499-bd10-8d9f9a5b901e_at_q5g2000yqh.googlegroups.com>
On Aug 25, 8:02 am, lsllcm <lsl..._at_gmail.com> wrote:
snip
> Hi All,
>
> I have one question about table design for Globalization in Oracle
> ERP. The following example is from Oracle ERP. Do I have other chocies
> to design table for this kind of requirement.
>
> CREATE TABLE product_information
> ( product_id NUMBER(6)
> , product_name VARCHAR2(50)
> , product_description VARCHAR2(2000)
> , category_id NUMBER(2)
> , warranty_period INTERVAL YEAR TO MONTH
> , supplier_id NUMBER(6)
> , product_status VARCHAR2(20)
> , list_price NUMBER(8,2)
> );
>
> CREATE TABLE product_descriptions
> ( product_id NUMBER(6)
> , language_id VARCHAR2(3)
> , translated_name NVARCHAR2(50)
> , translated_description NVARCHAR2(2000)
> );
>
> Thanks at first
> Jacky
Depending on what you select for database characterset VARCHAR2 and NVARCHAR2 may or may not be different. Received on Tue Aug 25 2009 - 08:30:30 CDT