I finally know what the problem is.
The problem is the new ODBC Driver (3.51.08). I wasn't sure until today,
because i uninstalled it (at least that's what i tried) and installed
version 3.51.06 again. But when i went to see the MyODBC3.DLL file it was
still version 3.51.08!! So i deleted this
I haven't been able to reproduce the problem on another computer.
I executed this query on control center and no longer get the 'x'...
update table set blob_field=null
where blob_field is null or blob_field=''
but problems continues... when i build a query that includes a datetime
field, i get
I have a query like this
select hex(blob_field) as myField from table
When the blob field is empty ('') it returns 'x'.
i'm using ADO with Visual Basic and MyODBC 3.51.
MySQL Version is 4.0.18 and SO is Win XP Pro (also happens on Windows 2K)
Felix Beltran.
Hi list...
I found that someone else had this problem:
http://lists.mysql.com/mysql/161614
But the solution is missing...
I couldn't find any other reference to this problem, does any one know the
answer?
Regards
FBR
[EMAIL PROTECTED]
13/07/2004 07:15 p.m.
To
[EMAIL PROTECTED], [EMAIL
Does any one knows how to store and retrieve files in blob columns using
VB .Net with ByteFx?
FBR
According to documentation there is a query log wich logs established
connections and executed queries, also there is the binary log wich
stores all statements that changes something (Used for replication)
So... if i do something like
update myTable set field1=AES_ENCRYPT('information',
Hi,
That's what i thought... but it makes no sense to me... it should be a way
to store data safely using MySQL encryption functions...
In the meantime... what are you using for encryption?
FBR
Matt W [EMAIL PROTECTED]
22/02/2004 08:24 p.m.
To
[EMAIL PROTECTED], [EMAIL PROTECTED]
cc
I would like to encrypt informaton in MySQL DB using the AES_ENCRYPT
function, but what if someone looks into the log files?
Unfortunately, i cannot prevent access to that computer...
FBR
That looks like a good solution...
Do you know if i can replicate multiple databases from diferent servers to
one server? many masters and one slave, the slave might have replicas of
each master database
(cause i need to query on many diferent mysql servers)
thanks...
FBR
Chris Nolan [EMAIL
Is it possible to query one server from another even if those servers are
in diferent machines at diferent locations?
for example:
select * from localtable left join remoteserver.remotedatabase.remotetable
where localtable.key = remoteserver.remotedatabase.remotetable.key
FBR
I'm just curious.. what kind of application(s) are you hosting in such a
server???
Santiago Flores [EMAIL PROTECTED]
26/09/2003 11:50 a.m.
To
[EMAIL PROTECTED]
cc
Subject
Mysql 64 bit vs. Mysql 32bit
Hello. We recently aquired a dual Opteron system to run mysql on. We were
previously
Due to complex query needs and the lack of subqueries in the current
production version of MySQL i have to use temporary tables, but there is
almost no information about the behavior of them in the manual.pdf
documentation file of mySQL database. Does any one know where to find more
Thanks!
Antony Dovgal [EMAIL PROTECTED]
25/09/2003 02:33 a.m.
To
[EMAIL PROTECTED]
cc
Subject
Re: Temporary tables
On Thu, 25 Sep 2003 02:26:28 -0600
[EMAIL PROTECTED] wrote:
1) What happens if two (or more) users create a temporary table with the
same name at the same time?
2)
I'm trying to execute a code with multiple SQL statement over VB 6.0. The
code includes the creation of temporary tables, multiple inserts and one
final select...
It looks like i can only excecut one single SQL statement... does any one
know how to fix that?
I can run the code with out
According to documentation, in MySQL version 4.0, it is possible to use
sub-selects, but i haven't found the correct syntax... Does any one know
how to do this?
I need someting like this:
Select a, (select sum(b) from T2 where T2.a=T1.a) as b from T1
15 matches
Mail list logo