Clay Shannon wrote:

>I created a domain, D_BOOLEAN, that is in actuality a char(1), in which to
>store values 'T' and 'F'
>
>
>
>However, when I attempt to insert a 'T' into that column, I get:
>
>
>
>:
>
>Incompatible column/host variable data type.Dynamic SQL Error.
>
>SQL error code = -303.
>
>conversion error from string "T".
>
>

Can you insert then 'T' or 'F' value direct using any SQL tool ???

Did you put any check constraint on that domain ?

The client uses the same charset on connect ? (I don't think this will
be a problem but have a look)

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005