Thanks Peter for your help , i have already correct my connection to fb seting the the character set to win1253 .

----- Original Message -----
From: peter_jacobi.rm
To: firebird-support@yahoogroups.com
Sent: Wednesday, November 05, 2003 8:51 PM
Subject: [firebird-support] Re: greek characters


Hi petdevis

--- In firebird-support@yahoogroups.com, "petdevis" <devis@i...> wrote:
> Hi all
> I'm trying to store rows into a firebird db having Greek characters.
> I have declared the types of table's fields as varchar with Character
> set
> WIN1253 and Collation PXW_GREEK. When I'm trying to post data that
> include
> Greek chars, the result is to get an error message saying:
> "ISC ERROR MESSAGE
> arithmetic exception, numeric overflow, or string truncation.
> Cannot transliterate character between character sets"

Are you testing using ISQL?

You must also set a connection character set. The database character
set tells FB in which encoding the data is to be stored. The
connection character set tells FB the encoding used in the
interface between your client (your app or tool).

>From windows programs you should typically use WIN1253
as connection character set. But maybe the Greek console window
uses another encoding. 'chcp' display the character encoding used.

Or use
'chcp 1253' to set the console window to WIN1253, then
start ISQL, then
set names WIN1253
to tell FB your connection charset, then open your DB.

Regards,
Peter Jacobi








Yahoo! Groups Sponsor
ADVERTISEMENT




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



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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