Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
None
-
None
-
Windows
Description
I'm seeing a corruption of the column names when calling SQLColumns() after calling SQLBindCol(hstmt, 4, SQL_C_WCHAR, ...)
Here is the output:
{{COLUMNS IN TABLE "INFORM_EMAIL_LIST":
Name Type Chars Size Default
---- ---- ----- ----- -------
int???? 4: int(11) 10 4
vcF??e -9: varchar(255) 255 1020
vcL?? -9: varchar(255) 255 1020
vcSe -9: varchar(255) 255 1020
vcEl -9: varchar(255) 255 1020 ''
dtC?d 9: datetime 0 6 0000-00-00 00:00:00
vcE??s -9: varchar(255) 255 1020 'UCASE(vcEmail)'
enF??d -9: varchar(255) 255 1020
dtL?n 9: date 0 0
num??s 4: int(11) 10 4 0
}}
See those question marks? And that "vcEL" column is actually named vcEmail. I think the driver is not converting the column names to wide characters correctly.
Here is a little information about the environment:
DBMS name: MySQL
DBMS version: 5.5.5-10.6.19-MariaDB
Driver name: myodbc8a.dll
Driver version: 08.00.0028
Driver ODBC version: 03.80