Re: storing files in database
Blob field may do the trick but wouldn't it easier to store it on the drive? - Original Message - From: "I.SivaramaKrishnan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 17:05 Subject: storing files in database Hi all, Basically I have a requirement where I have to store xml files in the database. The table that I visualised for the purpose will contain two columns, one being the key (varchar) and the other for the xml file. What data type should I use for the second column. Are there any inherent problems with the above mentioned design like size of the file, or any other limitations that I don't foresee. Please let me know your thoughts. Awaiting your reply. Thanks Regards I. Siva -- Sivaramakrishnan I AdventNet (India) Development center. Madras, India. Phone: 91 44 243 2414 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: [Fwd: storing files in database]
Some guys here lurk around only to get their problems solved and chuck off the minute any kindred list memeber solves it . For them it just feels so smart thinking that the list is the best place to get their work done without paying a dime . So all u guys intending to only take and not give from the list think twice . It doesn't really hurt to help others . So keep the wheel of this List moving ! - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] ; [EMAIL PROTECTED] Sent: Friday, February 16, 2001 3:23 PM Subject: Antwort: [Fwd: storing files in database] On 16.02.2001 10:08:26 I.SivaramaKrishnan wrote: NOTE: Since iam not a member of this group, please reply by cc`ing to my mail id. That's a behavior I never quite understood - you come to list seeking for advice. Fine. Next you say that you do not care at all about the list. Geez, if you want answers, it's *YOUR* responsibility to obtain them! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Fwd: storing files in database]
NOTE: Since iam not a member of this group, please reply by cc`ing to my mail id. -- Sivaramakrishnan I AdventNet (India) Development center. Madras, India. Phone: 91 44 243 2414 Hi all, Basically I have a requirement where I have to store xml files in the database. The table that I visualised for the purpose will contain two columns, one being the key (varchar) and the other for the xml file. What data type should I use for the second column. Are there any inherent problems with the above mentioned design like size of the file, or any other limitations that I don't foresee. Please let me know your thoughts. Awaiting your reply. Thanks Regards I. Siva -- Sivaramakrishnan I AdventNet (India) Development center. Madras, India. Phone: 91 44 243 2414 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: storing files in database
On 16.02.2001 10:05:54 I.SivaramaKrishnan wrote: Hi all, Basically I have a requirement where I have to store xml files in the database. The table that I visualised for the purpose will contain two columns, one being the key (varchar) and the other for the xml file. What data type should I use for the second column. I always use a MEDIUMTEXT type for this, see: http://www.mysql.com/doc/C/o/Column_types.html . Although the column allows you to store 16 MB of data, it maybe that you need to start mysqld with a larger max packet size, as the default is 1 MB, which may not be enough. Further, I store the values base64 encoded in the column, so that I don't need to take care of special characters like ', " or \0. This will also increase the datasize by about 33%. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: [Fwd: storing files in database]
On 16.02.2001 10:08:26 I.SivaramaKrishnan wrote: NOTE: Since iam not a member of this group, please reply by cc`ing to my mail id. That's a behavior I never quite understood - you come to list seeking for advice. Fine. Next you say that you do not care at all about the list. Geez, if you want answers, it's *YOUR* responsibility to obtain them! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php