If you want to save your BMP picture in the database and save the extension
as well you will need separate fields.
One for the picture content (BLOB) and another one for the extension (CHAR
or VARCHAR as Egor said)


Thanks
Emery
----- Original Message -----
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 09:10
Subject: Re: type data


> DWI CAHYO <[EMAIL PROTECTED]> wrote:
> >
> > can everybody help me, as i would like to save
> > extention (*.bmp.jpg) on mysql, which i use type data
> > ?
> >
>
> Use CHAR/VARCHAR column types to store extention:
> http://www.mysql.com/doc/en/CHAR.html
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Egor Egorov
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
>        <___/   www.mysql.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to