Subject | Re: [ib-support] character count with CHAR type on UNICODE charset |
---|---|
Author | Ivan Prenosil |
Post date | 2002-09-26T11:50:42Z |
> I have one simple question - when I insert value to CHAR(1) field onOf course. UNICODE_FSS uses variable length encoding -
> UNICODE_FSS database, SELECT returns 3 characters.
one character can be 1 to 3 bytes long. And because CHAR datatype
does not carry information about real string length ...
> Is this bug or feature?Neither. It is just result of inappropriate combinig of
variable length encoding and fixed length field.
You shoud use VARCHAR with UNICODE_FSS.
Ivan
http://www.volny.cz/iprenosil/interbase