Sails.js Waterline Model Storage

Question

I'm trying to store a large chunk of text as part of a model in Sails.js. However, it seems that the text is getting cut off after some length. Is there a limit set on how long the 'string' type can hold in a model? If so, what's the best way around it? For reference, I'm using sails-mysql as an adapter.

score 2 · Accepted Answer · answered Jun 28 '14 at 12:54

2

Yes, String is only 255 chars long on default (because thats the default length in the most databases).

Try to use

myfield: {
    type: "text"
}

As attribute - this should work.

(See: http://beta.sailsjs.org/#/documentation/reference/Models/Attributes.html)

answered Jun 28 '14 at 12:54

mdunisch

3,627
5
25
41

Hmmm... They don't show it in this table for some reason. http://sailsjs.org/documentation/concepts/models-and-orm/validations – Cody May 28 '16 at 19:16
That link is dead. Use this link as of lately. There's also longText and mediumText... http://sailsjs.org/documentation/concepts/models-and-orm/attributes – Cody May 28 '16 at 19:19

Sona Israyelyan · Answer 2 · 2018-10-25T06:44:10.970

0

Try to use field: { type: 'ref' } this creates longtext in mysql .

edited Oct 25 '18 at 06:44

answered Oct 24 '18 at 17:58

Sona Israyelyan

39
4

Sails.js Waterline Model Storage

2 Answers2