[firebird-support] character set

2012-02-20 Thread Olaf Kluge
Hallo, we have some problems by inserting data into an table. In our case, the customer inserts characters in a field varchar(XX) with special character “°”. This little ° with character set iso8859_1 and collation de_de by inserting generates a gds-exception error: 335544321 arithmetic excepti

[firebird-support] Character set

2015-10-14 Thread 'Bogdan' bog...@mordicom.si [firebird-support]
If someone can help me. I have a database with character set = none. That happened by mistake when upgrading dialect 1 database from 1.5 to 2.5. What is the procedure to change character set back to win1250 as it used to be. Any help will be appreciated. Regards, Bogdan

Re: [firebird-support] character set

2012-02-20 Thread Mark Rotteveel
On Mon, 20 Feb 2012 14:18:25 +0100, "Olaf Kluge" wrote: > Hallo, > > > > we have some problems by inserting data into an table. In our case, the > customer inserts characters in a field varchar(XX) with special character > “°”. This little ° with character set iso8859_1 and collation de_de by

Re: [firebird-support] character set

2012-02-20 Thread Stefan Heymann
> we have some problems by inserting data into an table. In our case, the > customer inserts characters in a field varchar(XX) with special character > “°”. This little ° with character set iso8859_1 and collation de_de by > inserting generates a gds-exception error: 335544321 arithmetic exception,

AW: [firebird-support] character set

2012-02-20 Thread Olaf Kluge
Hello, > we have some problems by inserting data into an table. In our case, the > customer inserts characters in a field varchar(XX) with special character > “°”. This little ° with character set iso8859_1 and collation de_de by > inserting generates a gds-exception error: 335544321 arithm

[firebird-support] Character set win1252 not installed

2012-07-31 Thread Wolfgang Kluge
Good evening. I will appreciate some help on how to install character set win1252. My firebird installation is a fresh FB 2.5.1 installation with all default values. When creating a new database with the following code: DB1.Connected := False; DB1.DBParams.Clear; DB1.DBParams.Add(

[firebird-support] Character set of parameter strings

2017-02-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Hello, All. When a string is sent to server via a query parameter, how is its character set determined: from XSQLVAR.sqlsubtype field or from connection's lc_ctype parameter? -- WBR, SD. +++

[firebird-support] CHARACTER SET WIN1252 is not installed

2013-06-27 Thread Leonardo M . Ramé
Hi, I've updated Firebird 2.5 on a FreeBsd 9.1 server. Usually I restore my databases using: gbak -c -v -REP -user USER -password PASSWORD bkp.ib database But, after the upgrade I'm getting this: gbak:restoring. ... gbak:committing metadata gbak: E

[firebird-support] Character set ISO8859_1 is not installed

2019-04-02 Thread Bart Friederichs b...@tbwb.nl [firebird-support]
I am connecting to a Firebird database through a WSGI setup on Apache, which is in the ISO8859_1 charset. This worked fine before, but after some updates, it broke. I connect like this: fdb.connect(dsn=local_copy, user='', password='', charset='iso8859_1') which gives me this error: Err

Re: [firebird-support] CHARACTER SET WIN1252 is not installed

2013-06-27 Thread Leonardo M . Ramé
On 2013-06-27 14:21:15 -0300, Leonardo M. Ramé wrote: > Hi, I've updated Firebird 2.5 on a FreeBsd 9.1 server. Usually I restore > my databases using: > > gbak -c -v -REP -user USER -password PASSWORD bkp.ib database > > But, after the upgrade I'm getting this: > > gbak:restoring

Re: [firebird-support] CHARACTER SET WIN1252 is not installed

2013-06-29 Thread Mark Rotteveel
On Thu, 27 Jun 2013 17:56:30 -0300, Leonardo M. Ramé wrote: > On 2013-06-27 14:21:15 -0300, Leonardo M. Ramé wrote: >> Hi, I've updated Firebird 2.5 on a FreeBsd 9.1 server. Usually I restore >> my databases using: >> >> gbak -c -v -REP -user USER -password PASSWORD bkp.ib database >> >> But, af

Re: [firebird-support] CHARACTER SET WIN1252 is not installed

2013-06-29 Thread Leonardo M . Ramé
On 2013-06-28 09:24:38 +0200, Mark Rotteveel wrote: > On Thu, 27 Jun 2013 17:56:30 -0300, Leonardo M. Ramé > wrote: > > On 2013-06-27 14:21:15 -0300, Leonardo M. Ramé wrote: > >> Hi, I've updated Firebird 2.5 on a FreeBsd 9.1 server. Usually I > restore > >> my databases using: > >> > >> gbak -c

Re: [firebird-support] Character set ISO8859_1 is not installed

2019-04-03 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2-4-2019 13:37, Bart Friederichs b...@tbwb.nl [firebird-support] wrote: > I am connecting to a Firebird database through a WSGI setup on Apache, > which is in the ISO8859_1 charset. This worked fine before, but after > some updates, it broke. > > I connect like this: > > |fdb.connect(dsn=loc

[firebird-support] Character set UTF8 and CZECH collation, via ICU

2014-10-19 Thread 'ZSE' fb-k...@centrum.cz [firebird-support]
    Hello,   I like Firebird database more than 10 years:-)   I always use for VARCHAR value character set WIN1250 and COLLATION PXW_CSY... Now I need to you UTF8 and I need to have correct CZECH collation...   I have found some information, I must use ICU and add collation to Firebird...   In marc