Mysql Embedded Server - case ?

Hi again

I'm using JConnector 3.0.6 and using MYSQL 4.0.12 and embedded server
and embedded server 4.0.4 beta (didn't install source, downloaded it
from some site). Anyway when I create database with JConnector
preparedstatement("CREATE DATABASE Blabla")
i get two different names, in the server i get "Blabla", but in the
embedded i get "blabla". Is that a bug or a option in the embedded
server?

Best regards
Ignacio




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Mysql Embedded Server - case ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

netmails@hotpop.com wrote:
| Hi again
|
| I'm using JConnector 3.0.6 and using MYSQL 4.0.12 and embedded server
| and embedded server 4.0.4 beta (didn't install source, downloaded it
| from some site). Anyway when I create database with JConnector
| preparedstatement("CREATE DATABASE Blabla")
| i get two different names, in the server i get "Blabla", but in the
| embedded i get "blabla". Is that a bug or a option in the embedded
| server?
|
| Best regards
| Ignacio

Two things...First, the embedded server doesn't work with Connector/J.
Second, it appears that you're running on Windows, which forces all
table names to be lower-case by default to avoid the case in-sensitivity
issues with Windows filesystems.

-Mark


- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

~ __ ___ ___ ____ __
~ / |/ /_ __/ __/ __ \/ / Mark Matthews
~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
~ /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
~ <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+ntmvtvXNTca6JD8RAvFYAJwO/huBPhU2qqYnOyPT+CIoA0NpoACg kcpd
WOFcbCrnOwJ9I36tVsxME2o=
=fKRb
-----END PGP SIGNATURE-----


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Mysql Embedded Server - case ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Martin wrote:
| Case Insensitivy disappeared with NTFS
| or should I say
| Case sensitivty appeared with NFTS
| is there another reason for lowercase table names?
| -Martin

Actually, it didn't. Many Win32 system calls still operate in a
case-insensitive manner. Read this portion in the MySQL manual to
understand why we enable lower_case_table_names on Windows:

http://www.mysql.com/doc/en/Name_case_sensitivity.html

-Mark


- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

~ __ ___ ___ ____ __
~ / |/ /_ __/ __/ __ \/ / Mark Matthews
~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
~ /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
~ <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+nt3atvXNTca6JD8RAucZAJ9ftu8D0Z0z9RsJFMoFKvDgqXOXGwCg uZ6M
sx+Np2yHfplfgpGfm8SHYPU=
=74Fc
-----END PGP SIGNATURE-----


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Mysql Embedded Server - case ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Martin Gainty wrote:
| Mark
|
| I dont use FAT32 anymore for that very reason
| NTFS correctly interprets case sensitivite filenames (e.g. FOO from foo)

NTFS is not case-sensitive, it is case-preserving. None of the system
calls dealing with filesystems in Win32 are case-sensitive. In fact, try
and create two files differing only in case in the same directory in
NTFS, you won't be able to (this is on an NTFS filesystem from WindowsXP):

C:\temp>echo "" > bar

C:\temp>echo "" > BAR

C:\temp>dir bar*
~ Volume in drive C is HPNOTEBOOK
~ Volume Serial Number is 709E-3C03

~ Directory of C:\temp

04/17/2003 12:33 PM 5 bar
~ 1 File(s) 5 bytes
~ 0 Dir(s) 5,170,049,024 bytes free


| When will this issue be corrected?

When the Win32 API allows it and Windows actually has case-sensitivity,
I would suppose.

-Mark
- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

~ __ ___ ___ ____ __
~ / |/ /_ __/ __/ __ \/ / Mark Matthews
~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
~ /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
~ <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+nueNtvXNTca6JD8RAmSqAJ0XKRV6nRynvaemsVF9jr3oUI2XSgCf bdFM
Uu/Kqd/bl0crOVeffm49qoc=
=Ifqg
-----END PGP SIGNATURE-----


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Mysql Embedded Server - case ?

Case Insensitivy disappeared with NTFS
or should I say
Case sensitivty appeared with NFTS
is there another reason for lowercase table names?
-Martin
----- Original Message -----
From: "Mark Matthews"
To:
Cc:
Sent: Thursday, April 17, 2003 9:43 AM
Subject: Re: Mysql Embedded Server - case ?


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> netmails@hotpop.com wrote:
> | Hi again
> |
> | I'm using JConnector 3.0.6 and using MYSQL 4.0.12 and embedded server
> | and embedded server 4.0.4 beta (didn't install source, downloaded it
> | from some site). Anyway when I create database with JConnector
> | preparedstatement("CREATE DATABASE Blabla")
> | i get two different names, in the server i get "Blabla", but in the
> | embedded i get "blabla". Is that a bug or a option in the embedded
> | server?
> |
> | Best regards
> | Ignacio
>
> Two things...First, the embedded server doesn't work with Connector/J.
> Second, it appears that you're running on Windows, which forces all
> table names to be lower-case by default to avoid the case in-sensitivity
> issues with Windows filesystems.
>
> -Mark
>
>
> - --
> For technical support contracts, visit https://order.mysql.com/?ref=mmma
>
> ~ __ ___ ___ ____ __
> ~ / |/ /_ __/ __/ __ \/ / Mark Matthews
> ~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
> ~ /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
> ~ <___/ www.mysql.com
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQE+ntmvtvXNTca6JD8RAvFYAJwO/huBPhU2qqYnOyPT+CIoA0NpoACg kcpd
> WOFcbCrnOwJ9I36tVsxME2o=
> =fKRb
> -----END PGP SIGNATURE-----
>
>
> --
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe: http://lists.mysql.com/bugs?unsub=mgainty@hotmail.com
>
>

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org