Opened 14 years ago
Closed 14 years ago
#730 closed defect (fixed)
GenericRdbms: cannot select from column with non-ASCII7 name
| Reported by: | brentrobinson | Owned by: | brentrobinson |
|---|---|---|---|
| Priority: | major | Milestone: | 3.6.0 |
| Component: | FDO API | Version: | 3.6.0 |
| Severity: | 2 | Keywords: | locale non-ASCII7 column name |
| Cc: | External ID: |
Description ¶
Steps:
- Create an MS Access database with one table that has a column with an accented (non-ASCII7) character in the name
- add some rows to the table.
- Write an FDO API application that does the following:
- Sets locale to the current one for the machine (setlocale(""))
- Connects to the database via the ODBC provider
- creates an FdoISelect on the class for the table.
- executes the select
- from the resultant reader, do a ReadNext()
- try to retrieve the value for the column with accented character.
An exception is throw with message "Column -1 not found"
Note:
See TracTickets
for help on using tickets.
Revision: 5835 Author: brentrobinson Date: 2:56:01 PM, Friday, November 26, 2010 Message: Ticket#730: Modified the FdoRDBMS packages to store column names in wide char, instead of UTF8, format.There are some places where case-insensitive comparisons are done for column names. These comparisons do not work when corresponding characters in the names to compare are:
Modified : /trunk/Providers/GenericRdbms/Src/Fdo/FeatureCommands/FdoRdbmsFeatureReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/Fdo/FeatureCommands/FdoRdbmsFeatureReader.h Modified : /trunk/Providers/GenericRdbms/Src/Fdo/Other/FdoRdbmsSQLDataReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/Fdo/Schema/FdoRdbmsSchemaUtil.cpp Modified : /trunk/Providers/GenericRdbms/Src/Fdo/Schema/FdoRdbmsSchemaUtil.h Modified : /trunk/Providers/GenericRdbms/Src/Gdbi/GdbiQueryResult.cpp Modified : /trunk/Providers/GenericRdbms/Src/Gdbi/GdbiTypes.h