Subject Re: Character set not preserved in view columns
Author zdeslav_v
hi Helen,

first of all, thanks a lot for your quick response

--- In, Helen Borrie <helebor@...> wrote:
> At 08:38 PM 18/04/2007, you wrote:
> DEFAULT CHARACTER SET X is not a statement, it is an optional clause
> of the CREATE DATABASE statement. If you do not specify a default
> character set for your database then it will be character set NONE
> and any derived fields you create will be NONE....
> Also, the SET... commands are not dynamic SQL statements, they are
> isql commands to enable you to set up CLIENT connection attributes
> inside an isql session in an interactive way. They work only in isql
> (although some are available to the precompiler in embedded
> applications via ESQL: the precompiler will convert them into calls
> to macros encapsulating the appropriate API function calls).

i know, this was just an excerpt from the script used to create the
but somehow i omitted the 'CREATE DATABASE...' part. sorry for that.
so, the
database is created with WIN1250 charset as default.

> >(i modified the generated system domain for full_name column
> >manually and that works)?
> Can't tell what that means.

in ibexpert i went to the definition of the system domain RDB$3 which
is the
domain of full_name column, and explicitly set the charset. sorry for
not being clear.
> >i suppose that i could modify the view column domain by changing some
> >entries in metadata tables,
> Hmmm, you shouldn't consider changing the metadata tables at all.

i don't like it either so this was more of a rhetorical question.

anyway, based on Ivan's tip, i installed v1.5.3.4870 and there
everything works as expected.

thanks again,