0 Replies Latest reply on Jun 6, 2005 10:26 AM by Laurent Duperval

    JBoss 3.2.5 ans SQL Server: using Y/N instead of 0/1 for boo

    Laurent Duperval Newbie


      We have legacy data that uses varchar(1) 'Y'/'N' for boolean values, instead of 0/1. Our database is SQL Server 2000. I'm trying to figure out how to make my booleans map to 'Y'/'N' instead of 0/1. In my configuration, I changed the follwing in standardjbosscmp-jdbc.xml:

      MS SQLSERVER2000



      I am using the latest jtds driver, but my boolean fields still map to 0/1 instat of Y/N.

      Can anyone help?