use uppercase names when adding text columns to indexes, which fixes long standing problem with table names starting with lowercase characters (and other situations where tables could not be opened in access)

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@94 f203690c-595d-4dc9-a70b-905162fa7fd2

2 files changed, 5 insertions, 6 deletions

diff --git a/src/java/com/healthmarketscience/jackcess/Database.java b/src/java/com/healthmarketscience/jackcess/Database.java
index b36471f..fd90579 100644
--- a/src/java/com/healthmarketscience/jackcess/Database.java
+++ b/src/java/com/healthmarketscience/jackcess/Database.java
@@ -334,16 +334,11 @@ public class Database
   public void createTable(String name, List<Column> columns)
     throws IOException
   {
-
     if(getTable(name) != null) {
       throw new IllegalArgumentException(
           "Cannot create table with name of existing table");
     }
     
-    //There is some really bizarre bug in here where tables that start with
-    //the letters a-m (only lower case) won't open in Access. :)
-    name = Character.toUpperCase(name.charAt(0)) + name.substring(1);
-    
     //We are creating a new page at the end of the db for the tdef.
     int pageNumber = _pageChannel.getPageCount();
     
diff --git a/src/java/com/healthmarketscience/jackcess/Index.java b/src/java/com/healthmarketscience/jackcess/Index.java
index d1a8321..69ca1e5 100644
--- a/src/java/com/healthmarketscience/jackcess/Index.java
+++ b/src/java/com/healthmarketscience/jackcess/Index.java
@@ -410,6 +410,10 @@ public class Index implements Comparable<Index> {
     public EntryColumn(Column col, Comparable value) {
       _column = col;
       _value = value;
+      if(_column.getType() == DataType.TEXT) {
+        // index strings are stored as uppercase
+        _value = ((_value != null) ? _value.toString().toUpperCase() : null);
+      }
     }
     
     /**
@@ -459,7 +463,7 @@ public class Index implements Comparable<Index> {
       if (_column.getType() == DataType.TEXT) {
         String s = (String) _value;
         for (int i = 0; i < s.length(); i++) {
-          Byte b = (Byte) CODES.get(new Character(Character.toUpperCase(s.charAt(i))));
+          Byte b = (Byte) CODES.get(new Character(s.charAt(i)));
           
           if (b == null) {
             throw new IOException("Unmapped index value: " + s.charAt(i));