when to use 'blob' in mysql

From: Stephen D (hellohello_at_hotmail.com)
Date: 11/28/03

Next message: Jeff Weiss: "Re: newbie question on spaces in echo"
Previous message: David Graham: "Re: newbie question on spaces in echo"
Next in thread: Andy Hassall: "Re: when to use 'blob' in mysql"
Reply: Andy Hassall: "Re: when to use 'blob' in mysql"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Fri, 28 Nov 2003 20:19:41 GMT

I am setting up a database using phpmyadmin and tried to enter a
'varchar' 400 char long but got an error saying max was 255 and to use
'blob' instead.

I have searched the forums to find out about 'blob' and it seems that
it is mainly used to store images in binary.

Can anyone tell me what the best mysql format is for a text field 400
char long is?

Will I have any trouble storing 400 char text as binary in a 'blob'
format?

Thanks

Next message: Jeff Weiss: "Re: newbie question on spaces in echo"
Previous message: David Graham: "Re: newbie question on spaces in echo"
Next in thread: Andy Hassall: "Re: when to use 'blob' in mysql"
Reply: Andy Hassall: "Re: when to use 'blob' in mysql"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Relevant Pages

Re: Invalid UNC path in my .NET applicaton
... I am having problems loading xml stored as a blob in an Oracle ... Exception Details: System.ArgumentException: The UNC path should be of ... System.IO.Path.nGetFullPathHelper(String path, Char[] ... String& newPath) +0 ...
(microsoft.public.dotnet.framework)
Invalid UNC path in my .NET applicaton
... I am having problems loading xml stored as a blob in an Oracle ... Exception Details: System.ArgumentException: The UNC path should be of ... System.IO.Path.nGetFullPathHelper(String path, Char[] ... String& newPath) +0 ...
(microsoft.public.dotnet.framework)