How to pass/convert a blob in a SQL

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
GEswin
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain
Contact:

How to pass/convert a blob in a SQL

Post by GEswin » Tue 04 Jan 2005 11:27

I have a few scripts where i update or insert records, specially using MyScripter. What should I do if I want to insert a blob (image or external file). With myQuery it works excellent when i pass it as a parameter, but with myscript I supose I have to encode it to some readable format, but I can't find out what.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: How to pass/convert a blob in a SQL

Post by Ikar » Wed 05 Jan 2005 09:52

MyDAC doesn't provide such service. You can read about quoting principles in MySQL Reference Manual mysql_escape_string

Post Reply