Re: Escape default value on CREATE TABLE

2018-06-14 Thread Yves PIEL
Thank you Matthew, I know how to set default value as you can see in my example cName.setDefault("O,K"); but it is not escape : "na-me" VARCHAR(255) DEFAULT O,K NOT NULL, Should be : "na-me" VARCHAR(255) DEFAULT "O,K" NOT NULL, isn't it ? Regards On 13 June 2018 at 19:39, Matthew Broadhead < mat

Re: Escape default value on CREATE TABLE

2018-06-14 Thread Matthew Broadhead
did you try cName.setDefaultString("O,K"); ? On 14/06/18 09:29, Yves PIEL wrote: Thank you Matthew, I know how to set default value as you can see in my example cName.setDefault("O,K"); but it is not escape : "na-me" VARCHAR(255) DEFAULT O,K NOT NULL, Should be : "na-me" VARCHAR(255) DEFAULT "O

Re: Escape default value on CREATE TABLE

2018-06-14 Thread Matthew Broadhead
this says you have to hack column definition https://stackoverflow.com/questions/197045/setting-default-values-for-columns-in-jpa maybe you could try surrounding with single quotes, like cName.setDefault("'O,K'"); On 14/06/18 10:34, Matthew Broadhead wrote: did you try cName.setDefaultString("O