[PonyORM-list] Encoding question

[Alexander Kozlovsky]

Hi Mark,

We've just pushed change to the github repository: now characted set is not
specified by default.

Now, if you specify an attribute in Pony:

    name = Optional(unicode, 255)

It will be translated to the following column definition:

    `name` VARCHAR(255) NOT NULL

If you want to have NULL as the default value for an Optional string
attribute instead of an empty string, then you can specify the option
'nullable=True' in the attribute definition:

    name = Optional(unicode, 255, nullable=True)

In this case, the column definition will look as

    `name` VARCHAR(255)

Pony doesn't append 'DEFAULT NULL' because in MySQL it is not necessary, it
is only NOT NULL that requires explicit declaration




On Tue, Jan 7, 2014 at 6:44 PM, Mark Nesterovych <m.nesterovych at gmail.com>wrote:

> Hello.
> I am trying to create a field in table which should look like this:
> `name` varchar(255) DEFAULT NULL
> But both types I've tried UNICODE and STR produces next statement:
> `name` varchar(255) CHARACTER SET utf8 NOT NULL
>
> How can I get rid of CHARACTER SET here ?
>
> Thank You.
>
> _______________________________________________
> ponyorm-list mailing list
> ponyorm-list at ponyorm.org
> /ponyorm-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </ponyorm-list/attachments/20140108/8637ba17/attachment.html>