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.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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.
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?
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.
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.
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
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?
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 ?
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.
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 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?
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?
MySQL C API Vector Binding Support?
I have a "slight" problem with the mySQL C API. I want to bind vectors for output/input prepared statements. However, the C API does NOT support such data binding. Is there ANY other way to do a bulk-INSERT/DELETE/UPDATE or bulk-SELECT in mySQL C API? I mean, one can do it with a loop, but obiously the goal is to have a higher performance.I tried it with a plain-old loop, but it is still slow. Oracle supports such feature and it is considerably faster than the usual loop-Insert (appr. 100 times faster for big queries) ! ! !
Client Does Not Support Authentication Protocol
If I create a user, say 'dbadmin' with full access on hosts 'All' and 'localhost' I cannot connect using PHP. I get the error: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client. If I make the connection with root on any of the local IP addresses the connection is fine and the database updates correctly. Any thoughts? I suspect a problem with the use of the socket, but phpinfo() correctly returns the mysql settings.
Oledb Provider With Transaction Support?
i downloaded oledb provider from mysql.com, i use Delphi's ADO. but i found that this oledb provider does not support transaction. is there any oledb provider that does support transaction?
Support Authentication Protocol Upgrade
I have been using a script on my server for 2 years today I get this message Is it the script or the server? Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home2/cruisew/public_html/cruisevacationcenter.net/test/inc/db_wrapper.php on line 11 AAAClient does not support authentication protocol requested by server; consider upgrading MySQL client
Multi-Language Support Before Version 4.1
I've seen from the documentation that support for the utf8 character set wasn't added until version 4.1. Most hosts aren't running this version yet, are multiple languages supported prior to version 4.1?
|
TRACKER
