[ODBC-18] only first half of each VARCHAR value is displayed in Excel Created: 2015-02-07 Updated: 2015-03-12 Resolved: 2015-03-12 |
|
| Status: | Closed |
| Project: | MariaDB Connector/ODBC |
| Component/s: | None |
| Affects Version/s: | 1.0.0 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Danny Read | Assignee: | Lawrin Novitsky |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Windows 7 Professional, Service Pack 1, 64-bit OS. |
||
| Attachments: |
|
| Description |
|
Load this in your MariaDB: insert into show_truncation (LABEL, A_NUMBER) VALUES ('ABCDEFGHIJKLMNO', 1234567890.0987654321), ('Z',9.87), ('YX',55555.55555), ('PQRS',1234); Use ‘Microsoft ODBC Administrator’ (32-bit version: C:\Windows\SysWOW64\odbcad32.exe) to create a DSN for your MariaDB database. Leave all the option checkboxes blank/unchecked. (screen shot and .xlsx file are attached below) More Info: Strangely, this additional sequence of steps shows the full values are being sent from the database. |
| Comments |
| Comment by Lawrin Novitsky [ 2015-03-12 ] |
|
I tried to reproduce the problem with current trunk version(master branch in the git repository), and values showed up not truncated. So, I hope the bug has been fixed by some other issue patch. I have couple of suspects. I am closing the bug for now. |
| Comment by Lawrin Novitsky [ 2015-03-12 ] |
|
Danny, I can provide binaries if you need/want them to verify the bug is really fixed. |
| Comment by Danny Read [ 2015-03-12 ] |
|
Yes, please (or are they already available in one of the regular builds?) |