> Problem with "CREATE DATABASE ... COLLATION ..." and 1 dialect
> --------------------------------------------------------------
>
> Key: CORE-4067
> URL: http://tracker.firebirdsql.org/browse/CORE-4067
> Project: Firebird Core
> Issue Type: Bug
> Components: Engine, ISQL
> Affects Versions: 3.0 Initial
> Reporter: Kovalenko Dmitry
>
>
> Firebird 3.0.0.30278
>
> c:\Program Files (x86)\Firebird_3_0>isql.exe
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> SET SQL DIALECT 1;
> SQL> CREATE DATABASE 'vxp-fb30:e:\database\test2.gdb' USER 'gamer' PASSWORD
> 'vermut' PAGE_SIZE 4096 DEFAULT CHARACTER SET win1251
> COLLATION win1251;
> Statement failed, SQLSTATE = 42000
> unsuccessful metadata update
> -ALTER DATABASE failed
> -Dynamic SQL Error
> -SQL error code = -817
> -Metadata update statement is not allowed by the current database SQL dialect
> 1
The COLLATION clause in CREATE DATABASE statement implemented using
ALTER CHARACTER SET statement which seems not supported in SQL dialect 1.
Probably, Adriano can comment more on this issue.
Regards,
Vlad
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
