heidisql - create database with uppercase Camel Case Format

Question

i create table with Tbl-ProductModifierGroup but on HeidiSQL it will display tbl-productmodifiergroup, how to slove this problem? Can i create table with CamelCase Format? which is Tbl-ProductModifierGroup

score 0 · Answer 1 · answered Oct 27 '14 at 09:22

This has nothing to do with HeidiSQL. Could you tell us what kind of DBMS you're running where you would like your table to be created? And please post a snippet of your CREATE code.

A sidenode before using camel case: keep in mind to check your DBMS for case sensitivity differences on platforms.

score 0 · Accepted Answer · answered Dec 10 '15 at 08:10

0

Just set the server variable lower_case_table_names to the value of 0 in your my.ini file:

[mysqld]
lower_case_table_names=0

But be aware of side effects mentioned on https://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html

answered Dec 10 '15 at 08:10

Anse

1,573
12
27

heidisql - create database with uppercase Camel Case Format

2 Answers2