View more context

 

Joe

IIRC that’s a MySQL config option: https://stackoverflow.com/questions/2659684/why-my-tables-names-are-converted-into-lowercase-in-phpmyadmin

Show 1 attachment(s)
Stack Overflow  
Why my tables' names are converted into lowercase in phpmyadmin?

I am using wamp server 2.0 on Windows XP. Whenever I create a table with some uppercases in name, it is converted to lowercase. For example: I create: UserInfo phpmyadmin convert it to: userinfo ...

Hide attachment content
Joe

how you recover from that for this specific issue, though, I’m not quite sure

Joe

looks like you can try setting lower_case_table_names to 2 to keep them lower case, but allow for case-insensitive table lookups

Jason Hale

thanks @Joe that's the path I'm heading down now. I thought 1 for that value would work but no go.

nightjarnz

the lower casing should work in both directions (identifiers in CamelCase should match tables in notcamelcase), I thought.

nightjarnz

try custom queries direct to the DB, perhaps it's something to do with SilverStripe enabling ANSI

jakx

Does anyone here have a strong preference for which pattern to use when creating a DataObject?

e.g

  1. $obj = MyDataObject::create([
  2. 'Field' => 'Value',
  3. ]);

vs

  1. $obj = MyDataObject::create();
  2. $obj->Field = 'Value';

vs something else?

jakx

I notice if the later is well annotated, code-intel gives those properties quicker references, and make them traversable, but there's repeated use of the $obj variable

nightjarnz

@jakx there is a critical difference in those two methods :)

😮 (2)
Firesphere

Added to my favourites 😄

😃 (1) 😄 (1)