Hey, the data in my DB isn't going to be in english, and I'm wondering if I should name the tables and the fields not in english as well, or there might be problems later when using the names in PHP or SQL code?
any one had experience with that?
54uydf
1
Junior Poster
Recommended Answers
Jump to PostAll reserved keywords of mysql are derived from english words. Therefore you are better off not using english words for table and column names to avoid conflicts.
Make sure that all components involved - database, tables, columns, server, clients etc. - use an appropriate character set, presumably utf8. Check the …
Jump to Postbut this makes me think that that's why I SHOULD use english..it's gonna be easier to write SQL queries where most of the command is gonna be in 1 language, I don't see why there should be a conflict.. :?:
I would say definitely avoid using SQL reserved words to …
All 5 Replies
smantscheff
265
Veteran Poster
54uydf
1
Junior Poster
d5e5
109
Master Poster
54uydf
1
Junior Poster
smantscheff
265
Veteran Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.