Hi list,
We are trying to find a DB2 way to implement the Oracle definition of

varchar2 (n char)

which stores n chars instead of n bytes.

How can we do this in DB2 ?

If you have DB2 9.7 you can also use VARCHAR2

Yes, but does it work the very same way?
does it do the same?


a definition like:

varchar2(n)

should behave different than

varchar2(n char)

Sorry, don't know about that.

Also you can use in any version of DB2:

Lenny

Yes but I am defining a Data Type.
What I want to achieve is to define a variable that contains n characters, not n bytes.

In Oracle this is defined as

myvar varchar2(2 char) ---> myvar will contain 2 CHARACTERS
myvar varchar2(2) ---> myvar will contain 2 BYTES

But that's in Oracle.

Now that DB2 9.7 is "oracle compatible", I wanted to know if there was some construct or definition that works the same way since the definition

myvar varchar2(2 char)

is not accepted in DB2 9.7.

You can use VARGRAPHIC or DBCLOB for double-byte character strings; the variable length will be understood to be given in double-byte characters.