Category: oracle

How to make Username Email case Insensitive in Symfony

What i need Username : [email protected] email address stored in db & input will be lowercase. there is no canonical field which has lower case email address stored. The solution select * from view where trim(lower(username))=trim(lower(input_username)) I read Url https://symfony.com/doc/current/security/user_provider.html…

Problem with symfony4/doctrine with oracle oci8 db

im having a problem while inserting new record to the database in Symfony 4 using doctrine/oracle/oci8 driver. My entity configration with sequence id generation: <id name=”id” type=”integer” column=”ID”> <generator strategy=”SEQUENCE”/> <sequence-generator sequence-name=”FILES_SEQ” allocation-size=”10″ initial-value=”1″/> </id> That’s how I insert new…