MYSQL :: Ssl Support In MAX Binaries?

Binaries For 4.x
Does anyone have an idea where I could obtain binaries for MySQL 4.x for
either SCO openserver release 5 or AIX 4.2.1

The binaries avalable from MySQL AB stop at version 3.22.32

MySQL Binaries On A K6-2?
I'm trying to diagnose a problem I'm having with MyISAM tables, and it
was recommended that I use the binaries instead of compile MySQL myself.
I noticed the binaries have 'i686' in their name.

Does this mean they are optimised for an i686, or will only work on an
i686? I have a K6-2 which only likes things compiled with -march=i586 or
-march=k6 Code:

Policy On Binaries
As you can see in downloads, 5.0.25 was released to "commercial customers" only. Is this the new policy that the 'community' will be stuck at 5.0.24a unless they want to bitkeeper?

I would think this would cause an exodus of people towards postgresql.

Please let me know the new policy so I can make an informed decision.

<snip>
D.1.2. Changes in release 5.0.25 (15 September 2006)

This is a bugfix release for the current production release family. This version was released as MySQL Classic 5.0.25 to commercial customers only.
</snip>

Difference Between Binaries And .msi
what is the difference between binaries and .msi installer for MySQL ? i am not very sure about that.
but what should i download from the particular website if i want to learn to create database using MySQL.

Utf8 Support
I would like to know the status of the UTF8 support in MySQL 4.1.

I tried to create a table using utf8 charset, and inserting hebrew text
into it. it seems like it still treats this text as binary - for example
the length() function returns 8 on 4 chars string, or when cretting a
column using varchar(4) i can only insert 2 letters to it.

So few questions:
1. Do you plan to support utf8 at this level, with all the string
functions working properly with utf8 (my first impression was that thats
what "utf8 support" is..).

2. What about fulltext search on UTF8 strings?
3. Is there any target date for releasing a stable version of 4.1?

How To Add MYSQL Support
i want to enable MySQL support in localhost. I am using Apache web server and PHP but i dont know how to enable MySQL support.

Ipv6 Support
i would like know about mysql's ipv6 support, i installed mysql 5.0.19 from a source dist and no configuration option is provided to enable ipv6.

XML Support In The Future?
I am quite new to MySQL & I have been looking for an XML database solution. I recently checked out the Berkeley DB XML specs, and noticed that the BDB engine is (or was) an optional part of MySQL - apparently used to support transactional capability.

My questions are these:
1. Is the BDB still used in current releases of MySQL for transactional support?

2. Has anyone heard of the addition of XML support to MySQL using the new Berkeley XML APIs to this engine?

Utf8 Support
I would like to know the status of the UTF8 support in MySQL 4.1.

I tried to create a table using utf8 charset, and inserting hebrew text
into it. it seems like it still treats this text as binary - for example
the length() function returns 8 on 4 chars string, or when cretting a
column using varchar(4) i can only insert 2 letters to it.

So few questions:

1. Do you plan to support utf8 at this level, with all the string
functions working properly with utf8 (my first impression was that thats
what "utf8 support" is..).

2. What about fulltext search on UTF8 strings?

3. Is there any target date for releasing a stable version of 4.1?

ODBC Not Support Utf?
my host only gives me ODBC connection to MySQL. i need the table to store some chinese characters and display them to the ASP.NET form. when i tested MySql connector on my dev machine, i added CHARSET=utf8 to the connection string and set the column charset to utf8 and it worked well. i did the same thing while using ODBC 3.51 Driver but all i saw was ????. am i missing anything or ODBC 3.51 Driver simply doesn't support utf?

PHP Support For MySQL
I am trying to configure PHP for the MySQL support. I am using redhat
8.0 with 2.4.18-14 kernel

[root@Server script]# uname -a
Linux Server 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux

MySQL was installed from the source in /usr/local/mysql/ directory and
the version is 4.1.8
[root@Server script]# /usr/local/mysql/bin/mysqladmin -V
/usr/local/mysql/bin/mysqladmin Ver 8.41 Distrib 4.1.8, for pc-linux
on i686

PHP was installed with OS and the version is
[root@Server script]# rpm -qa | grep php
php-4.2.2-8.0.5
php-imap-4.2.2-8.0.5
php-ldap-4.2.2-8.0.5

Now I want to configure PHP to support MySQL. There are some rpm in the
net for this, but these rpm cannot find mysql. I also tried to
uninstall PHP and install a new version of PHP from source. But PHP has
some dependencies.

Mysql Support OO?
Does mysql provide object oriented functionalities?

Sub Select Support
does any version of mysql support sub select
for example

for example

select deptno, ename, sal
from emp x
where sal > (select avg(sal)
from emp
where x.deptno = deptno)
order by deptno

if yes then tell me the version.

MySQL SSL Support
I am working under Microsoft Windows and I require a MySQL server with SSL support. I am running MySQL 5.0.6-beta-nt... my question is: how can I find out if my MySQL server supports SSL?

Somewhere I read that I have to compile it from source with SSL support... and on Windows that is almost impossible.

Mysql Support
if mysql4.1
support: sub-selects,
timestamp with timezones and sequences.

I think that sub-selects is supported.

Mysql's Support
I’m currently administering a small web-based application overseas which uses MySQL 5.0 as its database and running on Windows server OS.
The host computer’s date and time settings have been configured according to the country’s time zone where it is currently hosted and now observing daylight savings time.
My concern is that when the daylight savings time ends and moves back to standard time, will MySQL able to make the necessary changes in the time stamp of the data saved?
I’m just worried that the transition (back to standard time) will overwrite all the data that were saved during the last hour of the daylight savings time.
The application uses the data type DATETIME for storing the date and time stamp of the data being stored and the function NOW() in retrieving the host computer’s current date & time.

Support Authentication
i have installed php4.4 with iis and mysql5 and phpmyadmin is 2.5 version and mysql administration tool too i get the error client does not support authentication protocol,
i will be very pleased if someone suggest a good workin version for all mysql php and phpmyadmin

Do Triggers Support Transactions?
Do triggers in MySQL support transactions?

Also, are there any pros/cons of using triggers as opposed to stored procedures?

PHP, MySQL And Arabic Support
I wonder if you could help me with this problem.

I want to store and search Arabic text in MySQL database. I am running MySQL 4.1. and the collation is set to "cp1256_general_ci" for database, tabel and column.

Now, in PhpMyAdmin, if I run the following sql, it works:

Mysql Trigger Support
I would like to know if the following trigger functionality is supported in mySql v4 ?

i) I have one table called organisation, with lots of children tables. When a user
updates one of the children tables, I would like to UPDATE a column in table Organisation, i.e. Organisation.Lastupdate. Is this available in the latest version i.e. 4.*

ii) I would like to delete some child rows, if a row in the parent table is deleted. I can not for historical, schema definition reasons, use a cascade delete constraint.

Nanosecond Support For DATETIME
I'm porting the datastore for a Java application from MS SQL to MySQL 4.1, and I can't seem to support the granualarity of the DATETIME columns that are being written. MS SQL supported nanosecond granualarity in the applications DATETIME inserts, but apparently not my version of MySQL (or mysql-connector-java-3.0.16).

Before I start customizing the (400+) tables and code to add a separate nanosecond column (not a quick work around), is there a version of MySQL that supports nanosecond resolution?

Can MySQL Support UTF-8 Character Set
I am developing an web application which needs to support all kinds of
languages, like english, european character set, and other asian
character set. Therefore, UTF-8 can include all those characters.
But I am using MySQL4 as my application back-end database. MySQL4
doesn't support UTF-8 character set. How can I do it? Is there any
possible way that MqSQL can support UTF-8?

MyIsan Will Support Transactions?
I would like to know if mysql 5.0 myisan type will support transactions?

Does Mysql 3.23.51 Support Sub Queries?
the following:

SELECT customerNo AS Count FROM Customers WHERE customerNo = (SELECT MAX(customerNo ) FROM Customers );

gives:

ERROR 1064 : You have an error in your SQL syntax near '(SELECT MAX(customerNo ) FROM Customers )' at line 1

any ideas or alternatives to the above method? it works fine on mysql 5.0

Views Support In 5.0.0-alpha
from 1.8.5.6 Views:

"Views are currently being implemented, and will appear in the 5.0 or
5.1 version of MySQL Server."

i see the stored functions/procedures being added to the 5.0.0-alpha
release but i do not see any support for views still. are they going
to appear later in 5.0 or we would have to wait till 5.1 ?

How Many Database Does MySQL Support?
How many database does MySQL Support?

PHP MySQL And Arabic Support
I want to store and search Arabic text in MySQL database. I am running MySQL 4.1. and the collation is set to "cp1256_general_ci" for database, tabel and column. Now, in PhpMyAdmin, if I run the following sql, it works:

SELECT * FROM Arabic where t1='????'

However, I am also running this SQL in a PHP file, like:

<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());  }

mysql_select_db("ArabicTest", $con);

$result = mysql_query("SELECT * FROM Arabic where t1='????'") or die(mysql_error());

while($row = mysql_fetch_array($result))
  {
  echo $row['t1'];
  echo "<br />";
  echo $row['t2'];
  echo "<br />";
  } ?>

However, when I try to run the above sql from a php file, I get the following error:

Illegal mix of collations (cp1256_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' How can I solve this problem.

Native Delphi Support
I'm currently evaluating on moving an old Delphi/BDE application, to MySQL. I have never used it before, so i wanted to know if there is any native/oficial direct connection support. I'm not talking about ODBC drivers, i'm talking about some DLL, or delphi component that i can use. It has to be part of MySQL, as i don't want to depend on someone abandoning it.

Transaction Management Support
if MySQL supports transaction management - in relation to rolling back a database to a previous consistent state?

Version Support Views
My Question is that which version of MySQL supports Views.

Records MySQL Support
i'm doing my research on mysql. but i can't find how many records in 1 table mysql database can handle??

Client Does Not Support Authentication
The problem is that when i browse to http://reception/admin/index.php? and enter username and password I recieve the following message

1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

But i can log into mysql using the command prompt

PHP5 And MySQL Support
I am trying to compile apache2 with PHP5 with MySQL support. I run the configure command and everything run OK. I then run make then make install and i get no errors. However when i go to look at the phpinfo page -- with-mysql is not in the configure command and mysql sites are not working properly.

MySQL Support Inheritance
Does MySQL support inheritance?
i.e. I have Teacher, Student, etc. and they all inherit from Person because they share common attributes (name, address, etc).
I believe MySQL is not Object Orientated so it probably wont.
If so, how would I implement this in MySQL (I've been doing it with Oracle in the past and want to change over to MySQL)? Any
websites out there to show you?

Unicode And Japanese Support
I am using cold fusion to make a small custom website using
mysql to store the information a user inputs. I want it to
be able to save japanese and unicode text, but whenever I
enter any it comes back as garbage. Is there anything
special I need to do to configure mysql to use unicode

English And Arabic Text Support?
How can I make a MySQL table accept both English and Arabic text?

So far, I only know how to create a normal MySQL table with the following query:

CREATE TABLE `items` (
`id` INT(7) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 30 ) NOT NULL ,
`description` TEXT NOT NULL ,
`updated` INT( 10 ) UNSIGNED NOT NULL
);

What needs to be added to that to make it accept both English and Arabic inputs (for both title and description cols)?

Problems With Cyrillic Support On MySQL
I'm trying to insert cyrillic characters in my database but when I do select statement it lists the character as tons of question marks ??????
I'm using phpMyAdmin and my database and table collation are set to utf8_unicode_ci
Is there anything else that I need to set it, I'm I missing something?

Does MySql Support Oracle-like Ref Cursors?
Does anybody know if MySQL supports the ability for a stored procedure to return a "ref cursor" (Oracle term)?

Here is an example of an Oracle procedure that returns a ref cursor:

PROCEDURE my_proc
(a_out_cursor OUT ref cursor)
IS
BEGIN
open a_out_cursor for
select col_a, col_b
from my_table;
END;

I am using Java, so I would call this procedure as follows:

CallableStatement statement = null;
Connection connection = getConnection(); //returns a java.sql.Connection

//Use factory to get statement
statement = CallableStatementFactory.getCallableStatement(connection, "call my_proc(?)");

statement.registerOutParameter(1, OracleTypes.CURSOR);

// Execute the procedure
statement.execute();

I would like to perform this same sort of fetching using MySQL instead of Oracle. Does anybody know if it is possible? Or must all CallableStatements be setup as queries and not stored procedures?

Does MySQL 5.x Support Bit Encoded Strings?
Does mysql support storing bit encoded strings as a data type?

so something like this

10101010 can be stored, and is equivalent in size to a one byte datatype?

Does MySQL Support Binary Strings?
I want to have a sort of switchboard system on my database which tells which features are set and which ones are not...

01010110

That would tell you that some features are enabled and some are not. However when it comes down to storing the value I have two options...

1) Store it as a CHAR(8) value, and then fetch it without decoding it. Simply have a server side code use number.charAt(i) to determine the bit value.

2) Store it as a Decimal (Base10: 0-255) number and then have server side scripts covert it to base2 (binary). Then from there it will take the process that step one takes...

Both these solutions work well, But I would really like to have something in the middle. Say storing a base10 number (already decoded into base 2) but stores as a binary string. Is that possible?

How To Know If The Mysql Server Support Utf8?
how to know if the mysql server support utf8?

and how to know the default charset of the server?
(I have a normal use account)

Does Mysql Support Recursive Queries?
Does mysql support recursive queries?

MySQL Doesn't Yet Support LIMIT & IN/ALL/ANY/SOME Subquer
I try to make Query like this:

SELECT * FROM TABLE2 WHERE TABLE1ID IN (SELECT id FROM TABLE1 ORDER BY id ASC LIMIT 10);

But I get answer: ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

So my guestion is: How I can make same query but with the different way?

Does MySQL Support Oracle-like Ref Cursors??
Does anybody know if MySQL supports the ability for a stored procedure to return a "ref cursor" (Oracle term)?

Here is an example of an Oracle procedure that returns a ref cursor:

PROCEDURE my_proc
(a_out_cursor OUT ref cursor)
IS
BEGIN
open a_out_cursor for
select col_a, col_b
from my_table;
END;

I am using Java, so I would call this procedure as follows:

CallableStatement statement = null;
Connection connection = getConnection(); //returns a java.sql.Connection

//Use factory to get statement
statement = CallableStatementFactory.getCallableStatement(connection, "call my_proc(?)");

statement.registerOutParameter(1, OracleTypes.CURSOR);

// Execute the procedure
statement.execute();

I would like to perform this same sort of fetching using MySQL instead of Oracle. Does anybody know if it is possible? Or must all CallableStatements be setup as queries and not stored procedures?

Ssl Support In MAX Binaries?

Is ssl support provided in the MAX mysql binary distribution. The website lists some of the features provided in MAX that are not provided in the Standard binary. However, the website does not list the full list of features that are supported in the MAX but not in the Standard.