Case-insensitive objects in NDOutils

Hendrik Baecker andurin at process-zero.de
Tue Oct 27 08:57:48 CET 2009


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



Am 22.10.09 12:09, schrieb Ton Voon:
> Would 
> 
>    ALTER TABLE nagios_objects MODIFY name1 varchar(128) COLLATE
> utf8_bin NOT NULL default '';
>    ALTER TABLE nagios_objects MODIFY name2 varchar(128) COLLATE
> utf8_bin default NULL;
> 
> make more sense then? 

UTF8 _should_ be around the globe, but we all now how slow it turns ;)

May be I'm too free for the user with my wish to not decide for him
about the charset to use?
May be there are old installations out there with latin encodings. After
a switch over to utf8 they may get some ugly data outputs...

And a last "may be" we could switch over to the smallest common: 7Bit
ASCII? *kidding*
> 
> Can anyone with more mysql knowledge explain?
> 
> Ton
> 

Yes! More mysql knowledge and experience would be fine.

@Community: What do you think?

- -
Hendrik
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)

iEYEARECAAYFAkrmp/wACgkQlI0PwfxLQjm6KwCeLy2NHerlQDof75Gn6zyHF96T
+f8Ani5n0nYLEe7jgEIVm0Ru+cKrCfM+
=G8Av
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference




More information about the Developers mailing list