|
Home > Archive > MySQL ODBC Connector > February 2006 > Some general questions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Some general questions
|
|
|
| I was asked to scope out the following features, and am not the person to be
implementing them.
Hence the manuals weren't particularly helpful.
I'm looking for definitive references one way or the other for the following
questions.
SOS!
Does MySQL support the following:
- Support for DDL commands and dynamic SQL inside stored procedures?
- EXECUTE STATEMENT in Stored Procedures. (may be same question as above)
- Support for creation of databases inside stored procedures.
- Support for UTF-8 data storage in VARCHAR columns.
- Support of CLOBS or TEXT columns such that we can store up to 60,000 bytes
of TEXT data
____________________
____________________
____________________
_____
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Martijn Tonies 2006-02-28, 8:28 pm |
|
> I was asked to scope out the following features, and am not the person to
be
> implementing them.
> Hence the manuals weren't particularly helpful.
> I'm looking for definitive references one way or the other for the
following
> questions.
> SOS!
>
> Does MySQL support the following:
> - Support for DDL commands and dynamic SQL inside stored procedures?
Yes.
> - EXECUTE STATEMENT in Stored Procedures. (may be same question as above)
See above.
> - Support for creation of databases inside stored procedures.
I don't know, but it should be easy to try :)
> - Support for UTF-8 data storage in VARCHAR columns.
Yes.
> - Support of CLOBS or TEXT columns such that we can store up to 60,000
bytes
> of TEXT data
Yes.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www. databasedevelopmentf
orum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Peter Brawley 2006-02-28, 8:28 pm |
| --=======AVGMAIL-440499FA4093=======
Content-Type: multipart/alternative; boundary=------------ 09040205020205090309
0808
-------------- 09040205020205090309
0808
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
/>Does MySQL support the following:
>- Support for DDL commands and dynamic SQL inside stored procedures? /
Yes.
/>- EXECUTE STATEMENT in Stored Procedures. (may be same question as
above) /
Yes to a limited extent: PREPARE | EXECUTE accepts CREATE TABLE, DELETE,
DO, INSERT, REPLACE, SELECT, SET, UPDATE and most database info (SHOW)
commands.
/>- Support for creation of databases inside stored procedures. /
Yes
/>- Support for UTF-8 data storage in VARCHAR columns. /
Yes
/>- Support of CLOBS or TEXT columns such that we can store up to 60,000
bytes of TEXT data /
Yes.
PB
http://www.artfulsoftware.com
-----
J A wrote:
> I was asked to scope out the following features, and am not the person
> to be implementing them.
> Hence the manuals weren't particularly helpful.
> I'm looking for definitive references one way or the other for the
> following questions.
> SOS!
>
> Does MySQL support the following:
> - Support for DDL commands and dynamic SQL inside stored procedures?
> - EXECUTE STATEMENT in Stored Procedures. (may be same question as above)
> - Support for creation of databases inside stored procedures.
> - Support for UTF-8 data storage in VARCHAR columns.
> - Support of CLOBS or TEXT columns such that we can store up to 60,000
> bytes of TEXT data
>
> ____________________
____________________
____________________
_____
> On the road to retirement? Check out MSN Life Events for advice on how
> to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement
>
>
-------------- 09040205020205090309
0808
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<i>>Does MySQL support the following:
<br>
>- Support for DDL commands and dynamic SQL inside stored
procedures?
</i><br>
Yes. <br>
<i>>- EXECUTE STATEMENT in Stored Procedures. (may be same question
as above)
</i><br>
Yes to a limited extent: PREPARE | EXECUTE accepts CREATE TABLE,
DELETE, DO, INSERT, REPLACE, SELECT, SET, UPDATE and most database info
(SHOW) commands. <br>
<i>>- Support for creation of databases inside stored procedures.
</i><br>
Yes<br>
<i>>- Support for UTF-8 data storage in VARCHAR columns.
</i><br>
Yes<br>
<i>>- Support of CLOBS or TEXT columns such that we can store up to
60,000 bytes of TEXT data
</i><br>
Yes.<br>
<br>
PB<br>
<a class="moz-txt-link-freetext" href="http://www.artfulsoftware.com">http://www.artfulsoftware.com</a><br>
<br>
-----<br>
<br>
J A wrote:
<blockquote cite="midBAY20- F209ED79F781A8C7125D
7A2EEF70@phx.gbl"
type="cite">I was asked to scope out the following features, and am
not the person to be implementing them.
<br>
Hence the manuals weren't particularly helpful.
<br>
I'm looking for definitive references one way or the other for the
following questions.
<br>
SOS!
<br>
<br>
Does MySQL support the following:
<br>
- Support for DDL commands and dynamic SQL inside stored procedures?
<br>
- EXECUTE STATEMENT in Stored Procedures. (may be same question as
above)
<br>
- Support for creation of databases inside stored procedures.
<br>
- Support for UTF-8 data storage in VARCHAR columns.
<br>
- Support of CLOBS or TEXT columns such that we can store up to 60,000
bytes of TEXT data
<br>
<br>
____________________
____________________
____________________
_____
<br>
On the road to retirement? Check out MSN Life Events for advice on how
to get there! <a class="moz-txt-link-freetext" href="http://lifeevents.msn.com/category.aspx?cid=Retirement">http://lifeevents.msn.com/category.aspx?cid=Retirement</a>
<br>
<br>
<br>
</blockquote>
</body>
</html>
-------------- 09040205020205090309
0808--
--=======AVGMAIL-440499FA4093=======
Content-Type: text/plain; x-avg=cert; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Content-Description: "AVG certification"
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006
--=======AVGMAIL-440499FA4093=======
Content-Type: text/plain; charset=us-ascii
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
--=======AVGMAIL-440499FA4093=======--
| |
|
| Thanks!
With regard to the ClOBs or Text fields, is that CLOB support? Or support
for Text columns that hold up to 60,000 bytes of TEXT data?
>From: Peter Brawley <peter.brawley@earthlink.net>
>Reply-To: peter.brawley@earthlink.net
>To: J A < my_data_storage_65@h
otmail.com>
>CC: mysql@lists.mysql.com
>Subject: Re: Some general questions
>Date: Tue, 28 Feb 2006 12:44:08 -0600
>
>/>Does MySQL support the following:
>Yes.
>/>- EXECUTE STATEMENT in Stored Procedures. (may be same question as above)
>/
>Yes to a limited extent: PREPARE | EXECUTE accepts CREATE TABLE, DELETE,
>DO, INSERT, REPLACE, SELECT, SET, UPDATE and most database info (SHOW)
>commands.
>/>- Support for creation of databases inside stored procedures. /
>Yes
>/>- Support for UTF-8 data storage in VARCHAR columns. /
>Yes
>/>- Support of CLOBS or TEXT columns such that we can store up to 60,000
>bytes of TEXT data /
>Yes.
>
>PB
>http://www.artfulsoftware.com
>
>-----
>
>J A wrote:
[color=darkred]
>No virus found in this outgoing message.
>Checked by AVG Free Edition.
>Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>http://lists.mysql.com/mysql? unsub..._65@hotmail.com
____________________
____________________
____________________
_____
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/...1ave/direct/01/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Peter Brawley 2006-02-28, 8:28 pm |
| --=======AVGMAIL-4404AD260D05=======
Content-Type: multipart/alternative; boundary=------------ 06070505020100070904
0902
-------------- 06070505020100070904
0902
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
/> Thanks!
>With regard to the ClOBs or Text fields, is that CLOB support?
>Or support for Text columns that hold up to 60,000 bytes of TEXT data?
/
In MySQL they're 'BLOB's not 'CLOB's, see
http://dev.mysql.com/doc/refman/5.1...-overview.html.
PB
http://www.artfulsoftware.com
-----
J A wrote:
> Thanks!
> With regard to the ClOBs or Text fields, is that CLOB support? Or
> support for Text columns that hold up to 60,000 bytes of TEXT data?
>
>
>
>
>
>
>
>
> ____________________
____________________
____________________
_____
> Express yourself instantly with MSN Messenger! Download today - it's
> FREE! http://messenger.msn.click-url.com/...1ave/direct/01/
>
>
>
-------------- 06070505020100070904
0902
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<i>>Thanks!
<br>
>With regard to the ClOBs or Text fields, is that CLOB support? <br>
>Or support for Text columns that hold up to 60,000 bytes of TEXT
data?
<br>
</i><br>
In MySQL they're 'BLOB's not 'CLOB's, see
<a class="moz-txt-link-freetext" href="http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html">http://dev.mysql.com/doc/refman/5.1...e-overview.html</a>.<br>
<br>
PB<br>
<a class="moz-txt-link-freetext" href="http://www.artfulsoftware.com">http://www.artfulsoftware.com</a><br>
<br>
-----<br>
<br>
J A wrote:
<blockquote cite="midBAY20- F214459787EB214D1EB8
936EEF70@phx.gbl"
type="cite">Thanks!
<br>
With regard to the ClOBs or Text fields, is that CLOB support? Or
support for Text columns that hold up to 60,000 bytes of TEXT data?
<br>
<br>
<br>
<br>
<blockquote type="cite">From: Peter Brawley
<a class="moz-txt-link-rfc2396E" href="mailto:peter.brawley@earthlink.net"><peter.brawley@earthlink.net></a>
<br>
Reply-To: <a class="moz-txt-link-abbreviated" href="mailto:peter.brawley@earthlink.net">peter.brawley@earthlink.net</a>
<br>
To: J A <a class="moz-txt-link-rfc2396E" href=" mailto:my_data_stora
ge_65@hotmail.com">& lt;my_data_storage_6
5@hotmail.com></a>
<br>
CC: <a class="moz-txt-link-abbreviated" href="mailto:mysql@lists.mysql.com">mysql@lists.mysql.com</a>
<br>
Subject: Re: Some general questions
<br>
Date: Tue, 28 Feb 2006 12:44:08 -0600
<br>
<br>
/>Does MySQL support the following:
<br>
>- Support for DDL commands and dynamic SQL inside stored
procedures? /
<br>
Yes.
<br>
/>- EXECUTE STATEMENT in Stored Procedures. (may be same question as
above) /
<br>
Yes to a limited extent: PREPARE | EXECUTE accepts CREATE TABLE,
DELETE, DO, INSERT, REPLACE, SELECT, SET, UPDATE and most database info
(SHOW) commands.
<br>
/>- Support for creation of databases inside stored procedures. /
<br>
Yes
<br>
/>- Support for UTF-8 data storage in VARCHAR columns. /
<br>
Yes
<br>
/>- Support of CLOBS or TEXT columns such that we can store up to
60,000 bytes of TEXT data /
<br>
Yes.
<br>
<br>
PB
<br>
<a class="moz-txt-link-freetext" href="http://www.artfulsoftware.com">http://www.artfulsoftware.com</a>
<br>
<br>
-----
<br>
<br>
J A wrote:
<br>
<blockquote type="cite">I was asked to scope out the following
features, and am not the person to be implementing them.
<br>
Hence the manuals weren't particularly helpful.
<br>
I'm looking for definitive references one way or the other for the
following questions.
<br>
SOS!
<br>
<br>
Does MySQL support the following:
<br>
- Support for DDL commands and dynamic SQL inside stored procedures?
<br>
- EXECUTE STATEMENT in Stored Procedures. (may be same question as
above)
<br>
- Support for creation of databases inside stored procedures.
<br>
- Support for UTF-8 data storage in VARCHAR columns.
<br>
- Support of CLOBS or TEXT columns such that we can store up to 60,000
bytes of TEXT data
<br>
<br>
____________________
____________________
____________________
_____
<br>
On the road to retirement? Check out MSN Life Events for advice on how
to get there! <a class="moz-txt-link-freetext" href="http://lifeevents.msn.com/category.aspx?cid=Retirement">http://lifeevents.msn.com/category.aspx?cid=Retirement</a>
<br>
<br>
<br>
</blockquote>
</blockquote>
<br>
<br>
<blockquote type="cite">No virus found in this outgoing message.
<br>
Checked by AVG Free Edition.
<br>
Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date:
2/24/2006
<br>
<br>
</blockquote>
<br>
<br>
<blockquote type="cite"><br>
--
<br>
MySQL General Mailing List
<br>
For list archives: <a class="moz-txt-link-freetext" href="http://lists.mysql.com/mysql">http://lists.mysql.com/mysql</a>
<br>
To unsubscribe:
<a class="moz-txt-link-freetext" href="http://lists.mysql.com/mysql? unsub=My_Data_Storag
e_65@hotmail.com">http://lists.mysql.com/mysql? unsub..._65@hotmail.com</a>
<br>
</blockquote>
<br>
____________________
____________________
____________________
_____
<br>
Express yourself instantly with MSN Messenger! Download today - it's
FREE! <a class="moz-txt-link-freetext" href="http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/">http://messenger.msn.click-url.com/...1ave/direct/01/</a>
<br>
<br>
<br>
<br>
</blockquote>
</body>
</html>
-------------- 06070505020100070904
0902--
--=======AVGMAIL-4404AD260D05=======
Content-Type: text/plain; x-avg=cert; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Content-Description: "AVG certification"
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006
--=======AVGMAIL-4404AD260D05=======
Content-Type: text/plain; charset=us-ascii
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
--=======AVGMAIL-4404AD260D05=======--
| |
| Peter Brawley 2006-02-28, 8:28 pm |
| --=======AVGMAIL-4404D9111D60=======
Content-Type: multipart/alternative; boundary=------------ 05010803020307090005
0407
-------------- 05010803020307090005
0407
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
/> Thanks!
>With regard to the ClOBs or Text fields, is that CLOB support?
>Or support for Text columns that hold up to 60,000 bytes of TEXT data?
/
In MySQL they're BLOBs not CLOBs, see
http://dev.mysql.com/doc/refman/5.1...-overview.html.
PB
http://www.artfulsoftware.com
-------------- 05010803020307090005
0407
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<i>>Thanks!
<br>
>With regard to the ClOBs or Text fields, is that CLOB support? <br>
>Or support for Text columns that hold up to 60,000 bytes of TEXT
data?
<br>
</i><br>
In MySQL they're BLOBs not CLOBs, see
<a class="moz-txt-link-freetext"
href="http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html">http://dev.mysql.com/doc/refman/5.1...e-overview.html</a>.<br>
<br>
PB<br>
<a class="moz-txt-link-freetext" href="http://www.artfulsoftware.com">http://www.artfulsoftware.com</a><br>
<br>
</body>
</html>
-------------- 05010803020307090005
0407--
--=======AVGMAIL-4404D9111D60=======
Content-Type: text/plain; x-avg=cert; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Content-Description: "AVG certification"
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006
--=======AVGMAIL-4404D9111D60=======
Content-Type: text/plain; charset=us-ascii
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
--=======AVGMAIL-4404D9111D60=======--
|
|
|
|
|