[odb-users] COLLATE binary not existed in postgresql

[Boris Kolpackov]

Hi,

lg admin <lg.cookies at outlook.com> writes:

>  49     #pragma db key_options("COLLATE binary")                                                                                                              50     std::map<std::string, std::string> properties_;
> 
> It seems that COLLATE binary does not existed in postgresql. What would
> I do in postgresl for this use case? 		 	   		  

This is really a question about PostgreSQL specifically and not ODB. As
a result, it would be better to ask such questions on PostgreSQL-specific
mailing lists/forums/etc; you will probably get a better and faster
answer this way.

Having said that, a quick search brought this page:  

http://stackoverflow.com/questions/7778714/postgresql-utf-8-binary-collation

Which indicates that the PG equivalent would be COLLATE "C" or COLLATE
"POSIX": 

#pragma db key_options("COLLATE \"C\"")

It also points to the relevant Postgres documentation.

Boris