Does this CQD apply to the CREATE PROCEDURE statement too? On Wed, Apr 6, 2016 at 9:42 AM, Anoop Sharma <[email protected]> wrote:
> cqd traf_default_col_charset ‘UTF8’; > > > > > > > > *From:* Dave Birdsall [mailto:[email protected]] > *Sent:* Wednesday, April 6, 2016 8:36 AM > *To:* [email protected] > *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:[email protected]] > *Sent:* Wednesday, April 6, 2016 8:28 AM > *To:* [email protected] > *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.*
