PostgreSQL/SQLite issue - BINARY syntax invalid

Hi makangus !

Thanks you very much for your reply and patch.

Tested and it works under PG !

I notice that there is still a BINARY statement aroud:

  // we add 'BINARY' to ensure that we're doing a CASE SENSITIVE query
  $query = "SELECT * FROM {shurly} WHERE BINARY source = :short";
  if ($check_active) {

l874-876

Tested #4,

Everything looks fine: creation / reports / delete OK

Thanks for you quick reply !

One week later, still no problem !

Set this to RTBC

Is is possible to commit this :) ?

Committed against 7.x-1.x thanks ! Need to reroll for 6.x

The Drupal 6 API for changing field is a different from 7. We need to drop primary key and indexes in order to update the field.

Updated patch.

Reroll patch, need only to remove indexes from the field. Forgot to set the ouput.

Update patch, missing field definition.

Sorry again, this one should be OK.

Ok, my knowledge in Drupal 6 Schema was not helpful

Binary is not available as spec. Need to run a manual query

Updated patch.

Hope this will be the last one :)

Committed against 6.x-1.x

Thanks !