Michael,
lcPhoto doesn't have to be a PRIVATE variable, right? I could swear I've
seen this work with LOCAL scoped variables but I recall someone saying they
had to be private. My experiences found that advice to be wrong. ??
It works nicely with local variables.
Ed,
? SQLEXEC(1, "insert into t (rec_id, PhotoField) values (1, QUOTE('" +
lcPhoto + "'))" )
This doesn't work. lcphoto holds a bitmap so it is possible some characters
inside it to be "illegal" for MySql
set @@max_allowed_packet = NNN
This is a very good info. Thank you very much for that.
Sorry, I wish I could help you there. I have very little experience in
anything beyond utf-8.
I plan to store texts from various european languages( greek also), do you
believe that utf8 is best the choice?
----- Original Message -----
From: "Ed Leafe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 23, 2006 4:37 PM
Subject: Re: MySQL newbie strikes again!
On Aug 23, 2006, at 9:11 AM, Vassilis Aggelakos wrote:
Typing in the command window:
lcPhoto = Filetostr("c:\myphoto.jpg")
? SQLEXEC(1, "insert into t (rec_id, PhotoField) values (1, " +
lcPhoto + ")" )
I get an error saying that my syntax is not correct.
Does anyone know how this can be accomplished?
First, MySQL requires single quotes around strings. Second, strings need
to be escaped, since they may contain quotes, backslashes, and other meta
characters; use the MySQL Quote() function for this. So your statement
should look like:
? SQLEXEC(1, "insert into t (rec_id, PhotoField) values (1, QUOTE('" +
lcPhoto + "'))" )
You may also have a problem is the photo is large. There is a setting
called 'max_allowed_packet' that limits the largest command that MySQL
will accept. Check the docs for details on this, but the basic command
is:
set @@max_allowed_packet = NNN
where 'NNN' is the size you want. It should be at least as big as the
largest blob you will be working with.
<http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html>
( -or- http://tinyurl.com/exaop )
2. I create another field in my table and then I add a varhcar(50)
field. I mark BINARY flag and then click on "Save Changes" button. When
I reopen the properties of the field BINARY mark has gone!
Since this is a crazy behaviour I may have missed something very
essential. Does anybody know something about it?
I don't know what tool you're using, but there are two data types:
varchar and varbinary. The only time 'binary' is used with varchar is
when doing case-sensitive comparisons.
3. I create a field with column charset ="greek" and column colate =
"greek_general_ci". When I try ta save greek characters there and i get
error messages. Finally I managed to save greek characters with column
charset = utf8.
What's going here???
Sorry, I wish I could help you there. I have very little experience in
anything beyond utf-8.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
