> Date: Thu, 25 Jul 2002 11:41:45 -0400
> From: "Paul Schmidt" <paul@...>
> Subject: Re: Funny problem
>
> On 25 Jul 2002 at 14:39, Martijn Tonies wrote:
>
>
>>Hi Paul,
>>
>>
>>>>>I have a domain:
>>>>>
>>>>>CREATE DOMAIN "D_BICHAR_31" AS VARCHAR(31)
>>>>>CHARACTER SET WIN1252 COLLATE PXW_INTL850;
>>>>>
>>>>>And a field:
>>>>>
>>>>>DNAME D_BICHAR_31
>>>>>
>>>>>Yet I can't put 30 characters worth of data in this field, any
>>>>>idea as to why?
>>>>
>>>>No. But the error message might help, and the number of
>>>>characters you CAN put into the field, and the field size
>>>>and character length from rdb$fields. You should be able
>>>>to store 31 characters in a varchar 31, regardless of character
>>>>set. The collation affects the width of an index, but not the
>>>>storage size.
>>>>
>>>
>>>It seems to accept 20 characters but not 21 the error message is
>>>this:
>>
>>What characters are you putting in? ABCDEF...? Or special
>>characters?
>
>
> essentially A-Z, a-z, 0-9 and some of the ascii punctuation, like space -$.,# nothing
> out of the ordinary, even the high-ascii stuff is stripped out.
>
>
>>>SQL Message : -802
>>>Arithmetic overflow or division by zero has occurred..
>>>
>>>Engine Message :
>>>arithmetic exception, numeric overflow, or string truncation
>>>
>>>>From RDB$FIELDS
>>>
>>>RDB$FIELD_LENGTH = 31
>>>RDB$CHARACTER_LENGTH=31
>>
>>A non-unicode charset, right?
>>
>
>
> Win1252 which is I think Windows ANSI I may change it to straight ASCII and see if
> that makes a difference. As long as English is supported the client will be happy,
> although French and Spanish character extensions would always be appreciated.
>
>
>

Very strange,
I use without any problem :
CREATE DOMAIN DOM_LIEUX AS
VARCHAR(35) CHARACTER SET ISO8859_1
COLLATE FR_FR