You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@trafodion.apache.org by "Liu, Ming (Ming)" <mi...@esgyn.cn> on 2016/04/06 17:27:51 UTC

How to specify default charset of column in DDL create table?

Hi, all,

When create a table in Trafodion, by default, CHAR/VARCHAR columns will have ISO88591 as charset. Is there any way to change this default behavior, so by default, create table will have UTF8 as charset,without explicitly specify in DDL.

Thanks,
Ming

Re: How to specify default charset of column in DDL create table?

Posted by Gunnar Tapper <ta...@gmail.com>.
Does this CQD apply to the CREATE PROCEDURE statement too?

On Wed, Apr 6, 2016 at 9:42 AM, Anoop Sharma <an...@esgyn.com> wrote:

> cqd traf_default_col_charset ‘UTF8’;
>
>
>
>
>
>
>
> *From:* Dave Birdsall [mailto:dave.birdsall@esgyn.com]
> *Sent:* Wednesday, April 6, 2016 8:36 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: How to specify default charset of column in DDL create
> table?
>
>
>
> I had thought that CQD DEFAULT_CHARSET ‘UTF8’ would achieve this.
>
>
>
> But I tried it this morning, and it doesn’t seem to work. I still get
> ISO88591 by default on CREATE TABLE.
>
>
>
> Maybe something is broken.
>
>
>
> Dave
>
>
>
> *From:* Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
> *Sent:* Wednesday, April 6, 2016 8:28 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* How to specify default charset of column in DDL create table?
>
>
>
> Hi, all,
>
>
>
> When create a table in Trafodion, by default, CHAR/VARCHAR columns will
> have ISO88591 as charset. Is there any way to change this default behavior,
> so by default, create table will have UTF8 as charset,without explicitly
> specify in DDL.
>
>
>
> Thanks,
>
> Ming
>
>
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

RE: How to specify default charset of column in DDL create table?

Posted by Anoop Sharma <an...@esgyn.com>.
cqd traf_default_col_charset ‘UTF8’;

 

 

 

From: Dave Birdsall [mailto:dave.birdsall@esgyn.com] 
Sent: Wednesday, April 6, 2016 8:36 AM
To: user@trafodion.incubator.apache.org
Subject: RE: How to specify default charset of column in DDL create table?

 

I had thought that CQD DEFAULT_CHARSET ‘UTF8’ would achieve this.

 

But I tried it this morning, and it doesn’t seem to work. I still get ISO88591 by default on CREATE TABLE.

 

Maybe something is broken.

 

Dave

 

From: Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn <ma...@esgyn.cn> ] 
Sent: Wednesday, April 6, 2016 8:28 AM
To: user@trafodion.incubator.apache.org <ma...@trafodion.incubator.apache.org> 
Subject: How to specify default charset of column in DDL create table?

 

Hi, all,

 

When create a table in Trafodion, by default, CHAR/VARCHAR columns will have ISO88591 as charset. Is there any way to change this default behavior, so by default, create table will have UTF8 as charset,without explicitly specify in DDL.

 

Thanks,

Ming

RE: How to specify default charset of column in DDL create table?

Posted by Dave Birdsall <da...@esgyn.com>.
I had thought that CQD DEFAULT_CHARSET ‘UTF8’ would achieve this.



But I tried it this morning, and it doesn’t seem to work. I still get
ISO88591 by default on CREATE TABLE.



Maybe something is broken.



Dave



*From:* Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
*Sent:* Wednesday, April 6, 2016 8:28 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* How to specify default charset of column in DDL create table?



Hi, all,



When create a table in Trafodion, by default, CHAR/VARCHAR columns will
have ISO88591 as charset. Is there any way to change this default behavior,
so by default, create table will have UTF8 as charset,without explicitly
specify in DDL.



Thanks,

Ming