Subject Re: [firebird-support] Re: Zero prefix results in primary key constraint violation
Author Milan Babuskov
lutteroth89@... wrote:
> I think what I actually need is a character set without any blank
> characters. My application is trying to use arbitrary binary strings
> as keys, so whenever there is a blank character in the character set
> there will be two different binary strings that are treated as the
> same in indexes (i.e. PK constraint violation). Is there something
> like that?

You could store values in a regular char column but use their string
representation (converted to hexadecimal string for example).

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com