|
Treating the whole string as binary (and therefore case sensitivity and the like) would be too strong, I guess? Otherwise, replace() with binary datatypes might do the trick. Replies hidden
Yes, I should have known better, as I asked that a while ago: How do builtin string functions work with binary data? and Mark has explained that REPLACE() (pre-v17) does only work with character data and would convert binary input into character data...
(12 Oct '15, 05:13)
Volker Barth
|
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 09 Oct '15, 09:21
question was seen: 2,021 times
last updated: 12 Oct '15, 05:13
If you are just trying to come up with a 'key' to do sorting on you might wnat to review the "sort_collation" option but it sounds like you are intent upon some sort of translation.
As far as I can tell, that would need a collation-tailoring to accomplish this and there are only the 2 [Strng] functions SORTKEY( ) and COMPARE( ) that have that support. Neither of those will accomplish this by themselves.
It seems to require custom logic. External function logic may be a better solution.
yes we now use a external .net function to do the trick