FiveTech Software tech support forums

Remtec: En MySql puedes utilizar campos BLOB (TINYBLOB,BLOB,MEDIUMBLOB y LONGBLOB), dependiendo del tamaño de las imágenes a guardar. Saludos Hola Armando Muchas gracias por tu información. Par lo que tu me indicas, tendría que cambiar el proceso de DBF ...

Remtec: En MySql puedes utilizar campos BLOB (TINYBLOB,BLOB,MEDIUMBLOB y LONGBLOB), dependiendo del tamaño de las imágenes a guardar. Saludos Hola Armando Muchas gracias por tu información. Par lo que tu me indicas, tendría que cambiar el proceso de DBF ...

Remtec:

En MySql puedes utilizar campos BLOB (TINYBLOB,BLOB,MEDIUMBLOB y LONGBLOB),
dependiendo del tamaño de las imágenes a guardar.

Saludos

Dear Master, This column type (MEDIUMBLOB) is working properly. Thank you so much. Works with any language. Try this test: #include "fivewin.ch"function Main()   local oCn, oRs, cSql, aData   local cKey  := "abcdefgh"  ...

Hi,

It seems to be a Connector problem, because, if I test it with FIVEDBU, I have the same problem.
Does anyone alse use an other connector that can handle bigger BLOB fields?

... I'm using MariaDB and SQLite for my programs. With a setting, I can select the database I want to use. Now I just notice that I have problems with MEDIUMBLOB-fields in SQLite with more than 250 characters. Writing to the field is no problem. Checking the data with a SQLite-browse, I can see that ...

... syntax and also inserting into the RowSet using oRs:Append(...), if a RowSet is opened. Please ensure that the blob field is not minblob or mediumblob. largeblob is safer. Creating tables with FWH's oCn:CreateTable(...) is safe and avoids any possible problems in future. https://imagizer.imageshack.com/img921/4594/Qw8UNV.gif ...

Dear Mr.Rao,

I work as your sample but all image is files. I need to save backgroup (sea.bmp) to MEDIUMBLOB and logo (android.bmp) to MEDIUMBLOB or RESOURCE (RES)?

How can I do that?

Thanks in advance,

Marc, Can you try Mediumblob columns instead of Blob? Dutch, I'm also using upx to compress the exe-files, but than I'm also getting the message that the file is too big. Dear Marc, I use upx to compress the EXE file. It works well ...

Dear Mr.Rao, I used BITMAP for many year but when I move BMP file to MySQL field (Mediumblob). I saw the TIMAGE has support it. Which class that does support image from field instead of TXIMAGE? I suggest you use TImage instead of TXImage. TXImage is intentionally ...

Dear All, I used BITMAP as a background for Floor plan as picture but today I move BMP file to Mediumblob field in MySQL and use TXIMAGE instead. The problem is when I DRAG button and DROP button.  I'm not sure that TXIMAGE can use BITMAP replacement. https://s26.postimg.org/4yvsfsbqx/XImage.png ...

Thanks Narvarro and Armando,

I have another question, how to preview PDF in Mediumblob field in MySql?
Does the XIMAGE support PDF preview?

I read many post in forum, but it is no success case to preview PDF object?

Thanks in advance for any idea or suggestion.

Dear All, I have step to save receipt in PDF file format. If I save to Mediumblob field in MySql. 1. Is it stable to extract and re-use PDF file? 2. Does it make load time longer, when we fetch data of this table? Thanks for any idea and suggestion. If you ...

Dear All,

I have step to save receipt in PDF file format. If I save to Mediumblob field in MySql.
1. Is it stable to extract and re-use PDF file?
2. Does it make load time longer, when we fetch data of this table?

Thanks for any idea and suggestion.

Hola Foreros: Llevo varios días sin lograr sacar con éxito una imagen PNG que esta en un campo MEDIUMBLOB de una tabla MySql, lo curioso es que el mismo código para una imagen PDF sí funciona de 100. Este código con una imagen PDF va muy bien         IF oRsImg:Fields("HDR_PDF"):Value ...