Fw: 'x' on blob field when retrieving records
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 and MyODBC3D.DLL files, installed driver 3.51.06 again and now the datetime fields are working... is it a bug? - Forwarded by Félix Beltrán Ramos/dap on 21/07/2004 08:21 p.m. - Félix Beltrán Ramos/dap 15/07/2004 11:30 p.m. To Sergei Golubchik [EMAIL PROTECTED] cc [EMAIL PROTECTED], [EMAIL PROTECTED] Subject Re: 'x' on blob field when retrieving records 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 weird information. I debuged the application and instead of the datetime information, the recordset returns an string of 19 bytes... The grid on the UI interprets this information like japanese (or other) characters. Looks like the problem is in the ODBC driver, because another cliente machine connected to the same database doesn't get that results, and if the computer with this problem connects to another server with an identical database, it gets the same results... Has anyone ever seen this before?? FBR Sergei Golubchik [EMAIL PROTECTED] 14/07/2004 10:44 a.m. To [EMAIL PROTECTED] cc [EMAIL PROTECTED], [EMAIL PROTECTED] Subject Re: 'x' on blob field when retrieving records Hi! On Jul 13, [EMAIL PROTECTED] wrote: 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) If you can provide a repeatable test case, please submit a bugreport at bugs.mysql.com So far I was not able to repeat it: mysql create table a (b blob); Query OK, 0 rows affected (0.01 sec) mysql insert a values (NULL), (''), (0), ('aaa'); Query OK, 4 rows affected (0.02 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql select hex(b) from a; ++ | hex(b) | ++ | NULL | || | 30 | | 616161 | ++ 4 rows in set (0.01 sec) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com
Re: 'x' on blob field when retrieving records
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 weird information. I debuged the application and instead of the datetime information, the recordset returns an string of 19 bytes... The grid on the UI interprets this information like japanese (or other) characters. Looks like the problem is in the ODBC driver, because another cliente machine connected to the same database doesn't get that results, and if the computer with this problem connects to another server with an identical database, it gets the same results... Has anyone ever seen this before?? FBR Sergei Golubchik [EMAIL PROTECTED] 14/07/2004 10:44 a.m. To [EMAIL PROTECTED] cc [EMAIL PROTECTED], [EMAIL PROTECTED] Subject Re: 'x' on blob field when retrieving records Hi! On Jul 13, [EMAIL PROTECTED] wrote: 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) If you can provide a repeatable test case, please submit a bugreport at bugs.mysql.com So far I was not able to repeat it: mysql create table a (b blob); Query OK, 0 rows affected (0.01 sec) mysql insert a values (NULL), (''), (0), ('aaa'); Query OK, 4 rows affected (0.02 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql select hex(b) from a; ++ | hex(b) | ++ | NULL | || | 30 | | 616161 | ++ 4 rows in set (0.01 sec) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com
'x' on blob field when retrieving records
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.
Re: 'x' on blob field when retrieving records
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 PROTECTED] cc Subject 'x' on blob field when retrieving records 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.
ByteFX and blob
Does any one knows how to store and retrieve files in blob columns using VB .Net with ByteFx? FBR
Re: Encryption Issue
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', 'key') Any one who looks into the log file will be able to see the query, the information and the key, and all my information would be compromised... am i wrong? Regards FBR Frederic Wenzel [EMAIL PROTECTED] 22/02/2004 05:21 a.m. To [EMAIL PROTECTED] cc Subject Re: Encryption Issue [EMAIL PROTECTED] wrote: I would like to encrypt informaton in MySQL DB using the AES_ENCRYPT function, but what if someone looks into the log files? What ever may be logged by the mysql daemon - I can't believe it loggs passwords or the stored data itself. So why do you think so? bye Fred
Re: Encryption Issue
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 Subject Re: Encryption Issue Hi, - Original Message - From: [EMAIL PROTECTED] Sent: Sunday, February 22, 2004 3:18 PM Subject: Re: Encryption Issue 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', 'key') Any one who looks into the log file will be able to see the query, the information and the key, and all my information would be compromised... am i wrong? You're absolutely right. :-) Query contents can be seen in logs. That's why I do any encryption in the client code and only use the finished result in queries. Not sure how possible it is if you want to use AES encrytion, though. Matt
Encryption Issue
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
Re: Query to another server
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 PROTECTED] 17/02/2004 12:52 a.m. To Terence [EMAIL PROTECTED] cc [EMAIL PROTECTED] Subject Re: Query to another server You might be able to cheat and replicate the required database to the local machine. Regards, Chris Terence wrote: you'll need to create temporary tables in one of the servers based on the results of the other and then join. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 2:54 PM Subject: Query to another server 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Query to another server
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
Re: Mysql 64 bit vs. Mysql 32bit
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 using a dual Athlon MP system. We have encountered the following issue. We have a script that updates records in some rather large tables. This script runs more slowly on the opteron system than on the athlon system. The database was created on the athlon system an moved over. No tables or indexes were recreated. When benchmarking the two systems the opteron is much faster than the athlon system. This does not seem to carry over to our updates. Ideas? We have already (and are still open to more) tweaked my.cnf from the my-huge.cnf included in the Opteron binary from mysql.com (this is theirs, we haven't recompiled). We are running on SUSE8.2 for opteron. The opteron has 4GB of memory whereas the athlon had only 2GB. The tables are both on RAID5 on similar LSI controllers. The newer controller actually has better performance. Our my.cnf is included below. Any ideas on fixing this one? We really need this update query to run as quickly as it did on the athlon (at the very least). Some suggestions have been to recreate the tables and indexes using the 64bit binary on the opteron system. As this will take a while, would it have an effect? Anyone? I appreciate any comments, any direction. Thanks, Santiago -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Temporary tables
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 information about temporary tables?. The questions i would like to answer are: 1) What happens if two (or more) users create a temporary table with the same name at the same time? 2) If i don't drop the tables, when are the tables droped by the server? 3) what are the memory and or performance issues of temporary tables? 4) Can i use session based temporary tables? Regards, FB
Re: Temporary tables
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) If i don't drop the tables, when are the tables droped by the server? 3) what are the memory and or performance issues of temporary tables? 4) Can i use session based temporary tables? http://www.mysql.com/doc/en/CREATE_TABLE.html The temporary table is visible only to the current connection, and will be deleted automatically when the connection is closed. This means that two different connections can both use the same temporary table name without conflicting with each other or with an existing table of the same name. (The existing table is hidden until the temporary table is deleted.) From MySQL 4.0.2 on, you must have the CREATE TEMPORARY TABLES privilege to be able to create temporary tables. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Can't execute code in VB 6.0
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 problems using MySQL Control Center.
Sub-selects
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