On Thursday 30 August 2001 15:30, 520009199005-0001@... wrote:

> Hello all,
>
> I have a problem with the Charater Set ASCII, when I create a
> database. My Statement is
>
> CREATE DATABASE 'd:\dmb\database\dmb.gdb'
> USER 'sysdba' PASSWORD 'masterkey'
> PAGE_SIZE 1024
> DEFAULT CHARACTER SET ASCII;
>
> We use in germany the letters "ß","ü","ä" and "ö". The IB Version
> from us is V6.0.1.0.
> When we make an insert with the letters "ß","ü","ä" and "ö" an error
> occured.
>
> arithmetic exception, numeric overflow, or string truncation
> -Cannot transliterate character between character sets
> Statement failed, SQLCODE = -802
>
> I think the ASCII Default set working wrong.

Hi,

try this:

DEFAULT CHARACTER SET ISO8859_1;

works for me and I got German and French characters.

yves

> best regards from
>
> Klaus-Dieter Opitz (mailto:Klaus-Dieter.Opitz@...)
>
> mobil: +49 0179 1387265
>
> ESE GmbH
> Jasperallee 21
> 38102 Braunschweig
> Germany
>
> (http://www.ESE.de)
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Secure your servers with 128-bit SSL
> encryption! Grab your copy of VeriSign's FREE Guide: "Securing Your
> Web Site for Business." Get it Now!
> http://us.click.yahoo.com/n7RbFC/zhwCAA/yigFAA/dpFolB/TM
> ---------------------------------------------------------------------
>~->
>
> 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/