Gossamer Forum
(Advanced Search)
for
Home : Products : Others : MySQLMan :

import TEXT-type fields cut's them up

Mar 16, 2001, 5:27 AM
Meikel
Novice (10 posts)
Mar 16, 2001, 5:27 AM
Post #1 of 2
Views: 2388
Shortcut
Quote Reply
import TEXT-type fields cut's them up
hi,

when importing a csv-file through mysqlman, it cuts text-field that should have 64k after 255 characters. the database was created using dbman sql.

any hints?

Sep 20, 2001, 3:37 AM
Wil
Veteran / Moderator (4108 posts)
Sep 20, 2001, 3:37 AM
Post #2 of 2
Views: 2271
Shortcut
Quote Reply
Re: [Meikel] import TEXT-type fields cut's them up In reply to
You need to alter the field that's causing you problems to a field that can accept greater values of text.

What is it set to now? Has the field got a number in parenthesis after it? If so, what is it set to? 255 is the default therefore it would make sense that the database cuts it at this point.

Rgds

- wil