Subject Re: [firebird-support] Entering too much data into field
Author Aage Johansen
On Thu, 5 Feb 2004 09:33:28 +0000 (UTC), Riho-Rene Ellermaa wrote:

> FB 1.03 Windows
>
> CREATE TABLE DOM_PAY (
> ....
> BREF VARCHAR(20),
> ........
> );
>
>
> How can it be possible to enter into this field accented character?
>
> Someone has suceeded in that. When I try to do select on this row, I get
> th=
> e "Cannot transliterate ...." error.
> When I did backup and looked at the file, I saw this=20
> " Eksportuota =E1 archyv=F9 " - 00 15 14 45 6B 73 70 6F 72 74 75 6F 74 61
> 2=
> 0 E1 20 61 72 63 68 79 76 F9 00 06 05 49
>
> Shouldn't the "Cannot transliterate ...." error occure also in inserting?



Do you connect with the correct character set?
This character set should allow the characters you want to use, and
probably be the same as the default character set of the database. You
might try ISO8859_1.


--
Aage J.