Re: [Flamerobin-devel] COLLATE in procedure

[Milan B. <mi...@pa...>]

I also found this in my e-mail archive. I failed to find the commit that 
fixes it, so we might need to look into that as well before 0.9.4.

BaseSoft FIRMA wrote:
> I use everyday FlameRobin is a great tool.
> However, recently I found something inconsistent with ISQL.
> I created procedure that returns a variable containing COLLATE
> 
> Example: (Database Character Set: WIN1250)
> 
> Create procedure in FlameRobin
>   CREATE PROCEDURE P_Name (...)
>   RETURNS
>     (NAME_1 char (64) COLLATE PXW_PLK,
>      NAME_2 char (64) COLLATE PXW_PLK, ..... )
>   AS .....
> 
> When modify (alter) or recreated procedure (DDL), COLLATE PXW_PLK is removed.
> 
> DDL in FlameRobin:
>  
>    CREATE PROCEDURE P_Name (...)
>    RETURNS
>      (NAME_1 char (64),
>        NAME_2 char (64), ..... )
>     AS .....
> 
> Alter procedure in FlameRobin:
> 
>    ALTER PROCEDURE P_Name (...)
>    RETURNS
>      (NAME_1 char (64),
>        NAME_2 char (64), ..... )
>     AS .....
> 
> However, in ISQL everything is ok, when you create a procedure with COLLATE PXW_PLK and Extract Metadata procedure looks like:
> 
> CREATE PROCEDURE P_Name (...)
> RETURNS
>   (NAME_1 char (64) CHARACTER SET WIN1250 COLLATE PXW_PLK,
>    NAME_2 char (64) CHARACTER SET WIN1250 COLLATE PXW_PLK, ..... )
> AS .....
> 
> If possible, please fix.
> 
> Thanks.


-- 
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================