Hi All
I've only found one NG for MySQL and this doesn't seem to be that popular.
Does anybody know of a good NG (this one!!) or forum to post a query that I
have on preserving the case of my Win32 tablenames in my ASP/MySQL web app.
Please note that MySQL support ain't giving me nothing, but pointing me to a
gobbledegook page.
Rgds
Robbie
Please explain what you mean by "preserving the case of my win32
tablenames". Table names in SQL statements should not be case sensitive
(although I have found some problems in Oracle when using public synonyms
through ODBC).
--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Astra"
news:ebVxDVqNFHA.2468@tk2msftngp13.phx.gbl...
> Hi All
>
> I've only found one NG for MySQL and this doesn't seem to be that popular.
>
> Does anybody know of a good NG (this one!!) or forum to post a query that
I
> have on preserving the case of my Win32 tablenames in my ASP/MySQL web
app.
>
> Please note that MySQL support ain't giving me nothing, but pointing me to
a
> gobbledegook page.
>
> Rgds
>
> Robbie
>
>
Hi Mark
Thanks for your reply.
Found that when I executed my DDL script on a Win32 installation of MySQL
(v4.0.18) it converted all of my table names to lowercase.
The problem was that after I had filled the newly created DB with content,
backed it up and then restored it into my ISP's unix version of MySQL my web
app couldn't use any of the tables because I was querying them in UCase and
all of the tables were in LCase.
Thinking this was a fault with the MySQL Admin prog, I reported it as a bug,
but then after their support found that it was my Win32 installation that
was causing the LCase issue they wouldn't go into depth on the best method
to make my Win32 installation leave the case alone.
All I have from them is that I should specify the
lower_case_table_names='xx' command, but I don't if I should:
a) Put this command somewhere in my 'my.ini' file. If so, where?
b) What parameter should I specify for 'xx' to ensure that the above will
work OK. A couple of horror stories on the
http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html page stated
that if you get this wrong you could corrupt various areas of your DB.
"Mark Schupp"
news:%23ISnxctNFHA.2736@TK2MSFTNGP09.phx.gbl...
Please explain what you mean by "preserving the case of my win32
tablenames". Table names in SQL statements should not be case sensitive
(although I have found some problems in Oracle when using public synonyms
through ODBC).
--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Astra"
news:ebVxDVqNFHA.2468@tk2msftngp13.phx.gbl...
> Hi All
>
> I've only found one NG for MySQL and this doesn't seem to be that popular.
>
> Does anybody know of a good NG (this one!!) or forum to post a query that
I
> have on preserving the case of my Win32 tablenames in my ASP/MySQL web
app.
>
> Please note that MySQL support ain't giving me nothing, but pointing me to
a
> gobbledegook page.
>
> Rgds
>
> Robbie
>
>
So MySQL on Unix is case-sensitive with regard to table and column names?!
Have to keep that in mind next time a SQLServer vs MySQL discussion comes
up.
Can't help you much because I have no experience with MySQL at all. You'd
probably have more luck on a MySQL newsgroup.
--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Macsicarr"
news:OjMJr0uNFHA.2468@tk2msftngp13.phx.gbl...
> Hi Mark
>
> Thanks for your reply.
>
> Found that when I executed my DDL script on a Win32 installation of MySQL
> (v4.0.18) it converted all of my table names to lowercase.
>
> The problem was that after I had filled the newly created DB with content,
> backed it up and then restored it into my ISP's unix version of MySQL my
web
> app couldn't use any of the tables because I was querying them in UCase
and
> all of the tables were in LCase.
>
> Thinking this was a fault with the MySQL Admin prog, I reported it as a
bug,
> but then after their support found that it was my Win32 installation that
> was causing the LCase issue they wouldn't go into depth on the best method
> to make my Win32 installation leave the case alone.
>
> All I have from them is that I should specify the
> lower_case_table_names='xx' command, but I don't if I should:
>
> a) Put this command somewhere in my 'my.ini' file. If so, where?
>
> b) What parameter should I specify for 'xx' to ensure that the above will
> work OK. A couple of horror stories on the
> http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html page stated
> that if you get this wrong you could corrupt various areas of your DB.
>
>
> "Mark Schupp"
> news:%23ISnxctNFHA.2736@TK2MSFTNGP09.phx.gbl...
> Please explain what you mean by "preserving the case of my win32
> tablenames". Table names in SQL statements should not be case sensitive
> (although I have found some problems in Oracle when using public synonyms
> through ODBC).
>
> --
> Mark Schupp
> Head of Development
> Integrity eLearning
> www.ielearning.com
>
>
> "Astra"
> news:ebVxDVqNFHA.2468@tk2msftngp13.phx.gbl...
> > Hi All
> >
> > I've only found one NG for MySQL and this doesn't seem to be that
popular.
> >
> > Does anybody know of a good NG (this one!!) or forum to post a query
that
> I
> > have on preserving the case of my Win32 tablenames in my ASP/MySQL web
> app.
> >
> > Please note that MySQL support ain't giving me nothing, but pointing me
to
> a
> > gobbledegook page.
> >
> > Rgds
> >
> > Robbie
> >
> >
>
>
>
> So MySQL on Unix is case-sensitive with regard to table and column names?!
> Have to keep that in mind next time a SQLServer vs MySQL discussion comes
> up.
Well, many SQL Server installations on windows are also case- and/or
access-sensitive, it's just not the default -- so it's not strictly a MySQL
vs. SQL Server issue.
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.