Subject Re: where is ibconsole.exe ?
Author mailmur
I made a simple testdb without utf-8 charset then iboconsole.exe
worked fine. But its not what I need. If my db has UNICODE_FSS charset
it was able to list data, but most string values were garbage if
contained two-byte unicode (>127 ascii) letter.

My db applications _must_ support unicode from point to point. I could
use ISO-8859-1 to support finnish letters but then greek would be
impossible. To make letter problems go away unicode is only solution
so I must use UTF-8 charset in databases.

We currently use MySQL4.1 in a production use as it has a smooth
unicode support. phpMysqladmin have no problems with unicode 'cause
webbrowser does it well. But still some tasks are easier to do with
MySqlQueryBrowser or MySqlAdministrator windows applications.

Java and dotNet client applications have no problems rendering unicode
letters. But Javabased admin tools I've tried lack too much features.
Client applications are mostly java and dotnet what we use.

I havent tried FB2 which is said to have a unicode support. FB1.x
versions are practically problem when it comes to unicode (can store
even 6 chars to varchar(3) columns, string utf functions does not
work well, sorting and/or collation problems)

And hard to understand how to setup a proper utf-8 support, and then
clients dont break everything if connectionstrings miss a small charst
attribute. MSSQL server does it well without too much hassle, so do
current MySQL version and all functions and sortings work well.

I am planning on installing FB2 version at home and test how much
progress utf-8 support have.

> I am using the ISO8859_1 character set for a database in Norway. Using
> IBOConsole, I can update the tables with Scandinavian characters
> without problem.
> I think the error you are seeing is coming from the database. Since
> Unicode has multi byte characters, are you trying to enter more
> characters than the column width (in bytes) permits?

> > I downloaded IBOConsole and tested it with my current FB1.5.0.4290
> > installation. I have a database with UNICODE_FSS default charset.
> >
> > Registered localhost server, registered TESTUTF database and then
> > tried to insert non-USascii letters (a with two dots, a with ring
etc scandinavian letters).
> >
> > "Trying to post a new record it just gives me the following error.
> > ISC ERROR CODE: 335544321, aritmetic exception, numeric overflow,
or string truncation. Cannot transliterate character between character
> >
> > I have tried few Java based dbManagers but they lack too much
> > features. But Java and/or dotNet should give a smooth full unicode
> > support from point to point. Maybe native UIs, like IBOConsole,
dont cope with unicode charsets well enough.
> >
> > Table SQL
> > ============
> > CREATE TABLE "Customer" (
> > CONSTRAINT "PK_Customer" PRIMARY KEY ("id")
> > );