Tom Lane wrote:
An ideal solution would be to have a
"not-locale-affected-varchar" field type :)
If you're just storing ASCII then I think bytea might work for this.
Do you need any actual text operations (like concatenation), or this
just a store-and-retrieve field?
I've just tested bytea and it looks like a perfect solution - it supports:
- character-like syntax
- indexes
- uses indexes with LIKE 'x%' queries
- SUBSTRING()
That's good enough for us - it seems it's just what we need - a
string-like type with byte collation.
Thanks!
