search for: longtext

...hat I''m developing. I have a text entry in one my models that can sometimes be quite big. I tried setting :limit => 4294967296 on the text column in my migration file but this doesn''t seem to have any effect. The column is till created as a TEXT column rather than MEDIUMTEXT or LONGTEXT. Does anyone have any idea why this might be happening? Is there a better way of ensuring that an entry won''t default to TEXT in a mysql database? -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails:...

I have some files stored in db. When I try to download these I only get 65535 bytes from the database even if the file is a lot bigger. Is it a Rails setting I''ve missed or a database setting? Anything else? Using Rails 1.0, WinXP and MySQL4.1 /Marcus

As part of my project to put different types of results into worksheets, I would like to be able to put an auto-generated methods section. If I compose in RWinEdt, read into R, and use write.table with a .txt file extension, what I get out has line-breaks that correspond to those I put in in the first place. If I do the same thing but write.xls with .xls extention, I get an Excel worksheet

...| | | passwd | varchar(128) | YES | | NULL | | | name | tinytext | NO | | NULL | | | status | char(1) | NO | | A | | | type | char(1) | NO | | M | | | homeDir | longtext | YES | | NULL | | | mailDir | longtext | YES | | NULL | | | newEmail | varchar(128) | NO | | NULL | | +----------+--------------+------+-----+-------------------+-------+ Any help at all would be greatly appreciated...

I just upgraded the second half of a two node puppetmaster cluster and now I am having issues with puppet-dashboard report processing. If I have workers running on both servers, they try to process each others reports, but since the report data file is not there, it fails. I would have assumed this data was local, not in the database. Does anyone else have this issue, or have a suggestion

...xt field. My model looks like so: class Content < ActiveRecord::Base serialize :content end and my table : DROP TABLE IF EXISTS `contents`; CREATE TABLE `contents` ( `content_id` bigint(1) NOT NULL auto_increment, `tag` char(25) default NULL, `user_id` char(50) default NULL, `content` longtext, PRIMARY KEY (`content_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; What would be the correct way to validate data in this situation? Opinions/insight will be greatly appreciated thank you Tim

hi, I am using the R connect to mysql by RODBC, windows XP. when I use sqlQuery() to select blob columns from table, the result is binary type. but what i put into the blob column is character. and when using Perl, it is ok. i change the column data type to longtext. but this time, the sqlQuery() just gives me 255 characters. so, how can i do? this column composite with many numeric data, separated by ",". i just use the ID index to select this big field, about 24KB each field. this is the first time i use mailing list. hehe thanks in advance!...

Hi I''ve got the error in the log file "marshal data too short" after I try to store some data into session. After doing some research on the internet, it looks like the problem was caused by pstore.rb. It is there way to solve this problem? Thank you -- Posted via http://www.ruby-forum.com/.

...ult NULL, `deny` varchar(95) default NULL, `pickupgroup` varchar(10) default NULL, `port` varchar(5) NOT NULL default '', `qualify` varchar(4) default NULL, `restrictcid` char(1) default NULL, `rtptimeout` char(3) default NULL, `rtpholdtimeout` char(3) default NULL, `secret` longtext, `type` varchar(6) NOT NULL default '', `username` varchar(30) NOT NULL default '', `allow` varchar(100) default NULL, `disallow` varchar(100) default NULL, `regseconds` int(11) NOT NULL default '0', `ipaddr` varchar(15) NOT NULL default '', UNIQUE KEY...

...#39; I have been storing the file contents in a text field. I realise that I should seriously look at storing the files in s3 but this is the setup that I have at the moment. In postgres everything worked fine but in order to get things to work with mysql I had to set the :limit variable so that LONGTEXT was used instead of the standard text field. The files can be quite large but when I test using small files there are no problems I could be barking up the wrong tree entirely but I suspect that the problem may be caused by the database connection being dropped based on the errors thrown up when...

...Between I have article_groups as a jointable. Now I want to select every article who is a member of group with id ''1'' and id ''2''. Whats best way to get that? Extract from schemas: CREATE TABLE articles ( id int auto_increment, ingress text NOT NULL, story_text longtext, constraint fk_items_users foreign key (user_id) references users(id), primary key (id) ); CREATE TABLE groups ( id int auto_increment, name varchar(16) NOT NULL, description varchar(32) NOT NULL, constraint fk_items_users foreign key (user_id) references users(id), primary key (id) ); CREATE TABLE...

...label) and then make another list of, e.g., books on his bookshelf with the necessary columns (title, author, pub_date, shelf). The end user shouldn''t have to do any database programming, schema designs, etc. Just select the columns and types (from a very limited list -- date, text, longtext). Of course in PHP I could just have the program create tables and keep another table of the lists that has each column in a particular list in a row (list_num, name_of_list, column_name, column_type). Another way to do it that doesn''t result in the end user having to create new table...

This is apache/fcgi/rails/firefox. When using a rails app we have been experiencing sudden blank pages in the browser. We show an model "new object" page and start changing stuff and all of a sudden the page will be erased to blank! Any idea what could cause something like this? -- Posted with http://DevLists.com. Sign up and save your time!

Hello all, Has anyone done one of these? I''ve done similar things in java and php, by having easy access to SQL statements. I am new to Ruby/Rails( I''ve been at it for 10 days ) and thus far find it extremely confusing. I''ve got a bit more of a handle on it from the Agile book that someone loaned me, but I still find it hard to understand. Anyway, I''ve got