Hallo Pablo,
you have to define the characterset, when you create a database. And you must
define the same characterset in your connection. If not, then you receive
this error message.

Walter.

Am Dienstag, 22. Juli 2003 22:18 schrieb Pablo Lerner:

> Hello.
>
> I'm working with Spanish writing users who write characters like ñ,Ñ,á or Á
> and every charset I try doesn't work, even the WINxxxx one's, ASCII and
> UNICODE. The problem is that the server doesn't accept these characters
> ("Cannot transliterate characters between character sets"). Well, it
> accepts characters when they are inserted from a Fox Pro application, but
> it doesn't allow an update or delete of them later on, wich drives me
> crazy! how come the server does that ?
>
> For now, I just need if anyone can sugest me wich charset may work for
> spanish characters ?
>
> I've read the DataDefinition guide for Interbase 6.0 but I doesn't say
> which is the character table each set uses, and I don't know wich might
> work.
>
> I'm Using Firebird 1.02 and the client is written in VFP 7. Client run over
> W98 and server over WINNT. Also, the field I'm using for testing is
> referenced by some triggers. Could these have a negative impact on the
> test, each time I alter the field modifying the charset ?
>
> Thanks in advance...
>
> Pablo
>
> PS: was this letter well written or Tarzan written ?
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/