New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
COLLATE IN STORED PROCEDURES, OR IN PARAMETERS [CORE684] #1049
Comments
Commented by: @dyemanov I think we could support collations for PSQL parameters/variables. |
Modified by: @dyemanovassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] SF_ID: 1392665 => |
Modified by: @pcisarFix Version: 2.1 Alpha 1 [ 10150 ] SF_ID: 1392665 => Fix Version: 2.1.0 [ 10041 ] => |
Modified by: @pcisarWorkflow: jira [ 10708 ] => Firebird [ 15117 ] |
Commented by: @pmakowski Q/A tested |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: sgurgacz (sgurgacz)
Is related to QA101
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
Commits: 1a0df78
The text was updated successfully, but these errors were encountered: