Skip to content
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

Closed
firebird-automations opened this issue Dec 29, 2005 · 9 comments
Closed

COLLATE IN STORED PROCEDURES, OR IN PARAMETERS [CORE684] #1049

firebird-automations opened this issue Dec 29, 2005 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

I think we could support collations for PSQL parameters/variables.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Fix Version: 2.1 [ 10041 ]

SF_ID: 1392665 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

SF_ID: 1392665 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

SF_ID: 1392665 =>

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA101 [ QA101 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10708 ] => Firebird [ 15117 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pmakowski

Q/A tested

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants