Well, I usually don't work with ASCII, but most likely the ASCII
characterset in Firebird is pure 7 bit ASCII. So any character above
0x7F won't work.

To know which characterset you do need to use, you will need to ask the
company. If it is an American company, they might mean CP437 (or DOS437)
or ISO-8859-1 (ISO8859_1 or ANSI in Firebird). Most likely the last,
because people sometimes use ASCII when they mean ANSI.

Rick Debay wrote:

> I don't remember the exact error, but the column's character set is
> ASCII and the vendor sends us the character 0xC2. Firebird throws an
> exception that the character is invalid.
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Mark Rotteveel
> Sent: Wednesday, August 19, 2009 11:28 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Extended ASCII character set
>
> Then it is most likely not extended ASCII, but one of the ISO-8859-x
> charactersets. Also be more specific about what you mean with 'fails'.
>
> Rick Debay wrote:
>> We have a vendor that is sending us 8-bit ASCII characters. I tried
>> using Firebird's ASCII character set, but it fails on any extended
>> character.
>> Any suggestions as to what character set I should use?

--
Mark Rotteveel