> To know which characterset you do need to use, you will need to ask

the company.

Believe me, we have. We then get a lecture on how 8-bit ASCII has been
the standard for the last twenty-five years.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Mark Rotteveel
Sent: Wednesday, August 19, 2009 11:56 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Extended ASCII character set

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?

Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.