{"action":"opened","issue":{"url":"https://api.github.com/repos/schambers/fluentmigrator/issues/612","labels_url":"https://api.github.com/repos/schambers/fluentmigrator/issues/612/labels{/name}","comments_url":"https://api.github.com/repos/schambers/fluentmigrator/issues/612/comments","events_url":"https://api.github.com/repos/schambers/fluentmigrator/issues/612/events","html_url":"https://github.com/schambers/fluentmigrator/issues/612","id":84943908,"number":612,"title":"Oracle TypeMap must allow up to 4000 characters in VARCHAR2 / NVARCHAR2 fields","user":{"login":"jonnybee","id":3512406,"avatar_url":"https://avatars.githubusercontent.com/u/3512406?v=3","gravatar_id":"","url":"https://api.github.com/users/jonnybee","html_url":"https://github.com/jonnybee","followers_url":"https://api.github.com/users/jonnybee/followers","following_url":"https://api.github.com/users/jonnybee/following{/other_user}","gists_url":"https://api.github.com/users/jonnybee/gists{/gist_id}","starred_url":"https://api.github.com/users/jonnybee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jonnybee/subscriptions","organizations_url":"https://api.github.com/users/jonnybee/orgs","repos_url":"https://api.github.com/users/jonnybee/repos","events_url":"https://api.github.com/users/jonnybee/events{/privacy}","received_events_url":"https://api.github.com/users/jonnybee/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-06-04T06:38:24Z","updated_at":"2015-06-04T06:38:24Z","closed_at":null,"body":"see: [http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT1822](http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT1828) \r\n\r\n*The VARCHAR2 datatype stores variable-length character strings. When you create a table with a VARCHAR2 column, you specify a maximum string length (in bytes or characters) between 1 and 4000 bytes for the VARCHAR2 column*\r\n\r\nFluentMigrator has a limit of 2000 characters and if above will create a CLOB column. The limit should be altered to allow up to 4000 characters.\r\n\r\nThe same goes for NVARCHAR2 fields. \r\n*The maximum length of an NVARCHAR2 column is 4000 bytes. It can hold up to 4000 characters. The actual data is subject to the maximum byte limit of 4000.*\r\n\r\nI can submit PR if you will accept!"}}