Bug #39506 | Bug with the sintaxis show create table with odbc 5.1.4 | ||
---|---|---|---|
Submitted: | 18 Sep 2008 0:11 | Modified: | 18 Sep 2008 8:14 |
Reporter: | Edgar Valcarcel | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | Connector / ODBC | Severity: | S2 (Serious) |
Version: | 5.1.4 | OS: | Windows |
Assigned to: | Bogdan Degtyariov | CPU Architecture: | Any |
Tags: | bug, command, SHOW CREATE TABLE |
[18 Sep 2008 0:11]
Edgar Valcarcel
[18 Sep 2008 8:13]
Bogdan Degtyariov
Hello Edgar, Thanks for your interest to MySQL software. Your problem is related to the server metadata that is returned in binary(63) character set. Some functions results as "SELECT CONCAT("abc", 123)" will return the same unreadable result for your application. MyODBC driver has special option to avoid such problems. You can either set the DSN option in the MyODBC GUI dialog ([x] always handle binary function results as character data) or use the connection string parameter OPTION=268435456. I am marking this bug report as "Not a bug". Please let me know if the option has not helped.