SFID: 1392665#
Submitted By: sgurgacz

1.
Procedure like this, dosen't work, because of collate
in local parameters, and collate in local variable.
-------------------------
CREATE PROCEDURE NEW_PROCEDURE (
    LVNAZWISKO VARCHAR(35) CHARACTER SET WIN1250
COLLATE PXW_PLK)
AS
DECLARE VARIABLE AAA1 VARCHAR(35) CHARACTER SET
WIN1250 COLLATE PXW_PLK;
begin
end
--------------------------------

2.
Somthing like this works:
-------------------
SELECT * FROM AD_KOMORNICY WHERE UPPER(NAZWISKO
COLLATE PXW_PLK) = UPPER(:lvnazwisko)
--------------------


and this don't work
-------------------
SELECT * FROM AD_KOMORNICY WHERE UPPER(NAZWISKO) =
UPPER(:lvnazwisko COLLATE PXW_PLK)
---------------------
Column NAZWISKO ON AD_KOMORNICY IS TYPE OF :
VARCHAR(35) CHARACTER SET WIN1250 COLLATE PXW_PLK