|
Re: Create table using SQL Scrapbook [message #733495 is a reply to message #695495] |
Tue, 04 October 2011 21:44 |
Brian Payton Messages: 154 Registered: July 2009 |
Senior Member |
|
|
Hi Swati,
I suspect that is because VARGRAPHIC is a "double-byte" datatype. It
uses two bytes to encode the character, rather than one. (SQL was
developed before UNICODE was created.)
On 7/11/2011 2:50 PM, Swati Sapar wrote:
> I have connected to DB2 using the DTP framework.
> I am creating tables by typing the query in SQL Scrap book.(Right Click -Execute All)
>
> CREATE TABLE TableName(
> Column1 INTEGER,
> Column2 VARGRAPHIC(10),
> Column3 VARGRAPHIC(25),
> Column4 VARGRAPHIC(25),
> Column5 VARGRAPHIC(25),
> Column6 VARGRAPHIC(25),
> Column7 VARGRAPHIC(100)
> )
>
> The table is created fine, but the datatypes lengths seems to be doubled. Why is this so ?
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.03731 seconds