Issue Details (XML | Word | Printable)

Key: CORE-684
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: sgurgacz
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

COLLATE IN STORED PROCEDURES, OR IN PARAMETERS

Created: 29/Dec/05 12:00 AM   Updated: 07/Apr/08 10:00 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 2.1 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Relate
 

SF_ID: 1392665


 Description  « Hide
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

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 17/Jun/06 02:44 PM
I think we could support collations for PSQL parameters/variables.

Philippe Makowski added a comment - 07/Apr/08 10:00 AM
Q/A tested