Hi



I just went through the same problem.



Make sure that both Client and Server have the same character sets. I
use Win1252 but as soon as I set the column on the server to Win1252 AND
set lc_ctype=WIN1252 in the parameters of the TIBdatabase the problem
was solved.



Niall R Scott

IS Support

Cameron Controls

Aberdeen

scottn@...



****************************************************
This e-mail is confidential, may contain proprietary information of the
Cooper Cameron Corporation and its operating Divisions and may be
legally privileged.
This e-mail should be read, copied and/or used only by the addressee. If
you have received this message in error please delete it, together with
any attachment(s), from your system.
****************************************************

-----Original Message-----
From: delphi4everybody <DELPHI4ALL@...>
[mailto:DELPHI4ALL@...]
Sent: 27 December 2002 20:41
To: ib-support@yahoogroups.com
Subject: Re: RES: [ib-support] Problems with portuguese accents in
Interbase 6 .5/DbExpress



HI
I´m receiving the error when trying to run the aplication inside the
Ide.

ISC ERROR CODE 335544321
Class EdatabaseError with message
Arithmetic exception,numeric overflow, or string truncation

Cannot transliterate characters between character sets.
Process Stoped
When i execute it without Delphi the error is not being showed but
the record is not posted.


This is not a delphi error,because i tried to edit the table with IB
Workbench
And the error continues.

I change the Character set to Win1251 but error continues.
I´ve tried to backup and restore the Database and the error
continues.

I´m using Interbase 6.5 and windows Xp Professional.

Is Interbase 7 available?

Regards,
Marcello Dias
--- In ib-support@yahoogroups.com, Marcelo Pitanga
<marcelopitanga@h...> wrote:

> I'm using character set WIN1251 collate WIN1251 and work fine.
>
> []'s
> Marcelo Pitanga
>
> > ----- Mensagem original -----
> > De: delphi4everybody <DELPHI4ALL@H...>
> > [SMTP:DELPHI4ALL@H...]
> > Enviada em: sexta-feira, 27 de dezembro de 2002 14:56
> > Para: ib-support@yahoogroups.com
> > Assunto: [ib-support] Problems with portuguese

accents in

> > Interbase 6.5/DbExpress
> >
> > Hi,
> >
> > I´m having trouble with applyupdates when i´m using records with
> > portuguese accents,the records are simply not post and no

message is

> > being showed.
> > When i use no accents everything goes well.
> > When i use the same sample with Oracle it works well with

portuguese.

> > I´m using the iso8859_1 charset
> > Delphi 7,interbase 6.5 ,dbexpress
> >
> > Regards,
> > Marcello Dias
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

> >

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]