Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

Can I change the datatype for the "Create Table" field in the Show Create Table function in MySQL?

⇧
0
⇩
86 views

I'm trying to read the value from Show Create Table over ODBC. MySQL 3 seems to let me read it as a blob, but MySQL 5 doesn't and if I read it as a string I only get 255 characters (using Pascal Strings)

...maybe I should have omitted that previous sentence but I'm working with some good old musty code and the question itself is still valid.

  • MySQL 3 returns a blob, which works for me.
  • MySQL 5 returns a char which doesn't work.

Is it possible to make MySQL return a blob instead of a char for "Show Create Table"?

mysql datatypes char blob sqldatatypes
asked January 10, 2011 4:49 pm CST
Peter Turner
posted via StackOverflow

0 Answers

Be the first to answer this question

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Foreign key constraints missing from SHOW CREATE TABLE output
December 28, 2010
MySQL - Aren't these privileges enough to create a table?
January 3, 2011
Convert Simple T-SQL DDL to MySQL DDL (Create Table)
January 6, 2011
Show TABLE status and return 1 field
January 4, 2011
How to use constants in SQL CREATE TABLE?
December 31, 2010
[Solved] SQL CREATE TABLE Error
January 9, 2011
Trigger: after insert create a new table
January 7, 2011
Hibernate: hbm2ddl.auto does not create table
December 28, 2010
Codeigniter: I would like create user URL's for my users when they create a username
January 8, 2011
Change a mySQL Column datatype from text to timestamp
January 5, 2011
MySQL select one field from table WHERE condition is in multiple rows
December 29, 2010
Using python to write mysql query to csv, need to show field names
January 6, 2011
Populating a table with a large amount of data from a temporary table - MySQL
January 5, 2011
Ordering field in sql table - updating from jquery
January 10, 2011
How do I replace all my NULL values in a particular field in a particular table?
January 7, 2011
MYSQL inserting records form table A into tables B and C (linked by foreign key) depending on column values in table A
January 7, 2011
How can I split up a string field sentence into words and insert them into a new table with the same key id ?
December 27, 2010
MySQL: Log only drop/create commands
December 23, 2010
Trying to create a MYSQL advanced search
January 6, 2011
How to insert/create stored procedures in mySQL from PHP?
January 1, 2011
How to create a "unique" constraint on a boolean Mysql column?
January 6, 2011
Insert into table from temporary table takes a long time
January 10, 2011
How do I workaround this error ? You can't specify target table my table for update in FROM clause
January 9, 2011
Creating MySQL tables question, why some people create two tables that relate to each other instead of one?
January 4, 2011
Mysql : how to create custom unique key combination based on year and a unique no.
December 28, 2010
Create folder on ftp
January 4, 2011
Should I create a new DB column or not?
January 4, 2011
Default MySQL user privileges after executing CREATE USER
December 21, 2010
Possible to change To: field in email header?
January 2, 2011
Need to create http webserver using Qt 4.7 in C++
December 30, 2010