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]