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

Builtin functions converting binary string to hexadecimal representation and vice versa [CORE6049] #6299

Closed
firebird-automations opened this issue Apr 14, 2019 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @alexeykovyazin

FB4 already contains functions to transform binary strings to base64 format. That's useful functions but our clients also need hex form. They are building (using firebird stored procedures) various messages in XML and JSON formats which requires hex (not base64) representation of binary data (keys, hashes, etc.). It's highly desired to add such functions to FB4.

Commits: 5cbd2aa

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

reporter: Alexander Peshkov [ alexpeshkoff ] => Alexey Kovyazin [ alexey.kovyazin ]

Fix Version: 4.0 Beta 2 [ 10888 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @aafemt

Explicit function is fine, but Oracle, for example, does such conversion automatically on cast (both explicit and implicit) of binary data to string and vice versa.

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Not an option for us - our traditional behavior for none & octets is byte2byte copy. Afraid changing this can break a lot.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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