1 Reply Latest reply on Nov 25, 2005 5:07 AM by Emmanuel Bernard

    Case insensitve primary key

    Martin Ganserer Novice


      I have got a little problem. I have an entity bean: article.
      The primary key of the article object is the article no. The article no. is created by manual input. If I persist an article it works nearly without any problem.
      Normally our article numbers are capitalized (e.g. R10XS08). Today I created a new article number R10xs08. After I took a look at the database table I found that EJB changed the number to upper case: R10XS08.
      I am using a MySQL-Database. Is this a bug? Did I made a mistake?

      Thank you!