Subject | Re: Zero prefix results in primary key constraint violation |
---|---|
Author | lutteroth89@ymail.com |
Post date | 2009-02-10T23:21:48Z |
Hi again!
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?
Cheers,
Christof
> > Thanks. That clears things up. Is there a character set where 0x00 isI think what I actually need is a character set without any blank
> > not a blank character?
>
> AFAIR, all character sets except of OCTET. I.e. only OCTET have
> 0x00 as a blank character.
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?
Cheers,
Christof