> The problem is that I dont want it case sensitive, but
> I do want it to distinguish special characters, any
> more ideas?
You can't do this without a recompilation of MySQL.
The manual sec. 4.6.3 - "Adding a New Character Set"
gives a thorough explanation on how to go about it.
/ Carsten
--
The problem is that I dont want it case sensitive, but
I do want it to distinguish special characters, any
more ideas?
Thanks
Shannon
--- Michael Brunson <[EMAIL PROTECTED]> wrote:
> On Fri, 21 Dec 2001 11:07:27 -0800 (PST), Shannon
> Kendrick <[EMAIL PROTECTED]> wrote:
>
> | I have a mysql tab
On Fri, 21 Dec 2001 11:07:27 -0800 (PST), Shannon
Kendrick <[EMAIL PROTECTED]> wrote:
| I have a mysql table (MySAM), a field in there is set
| to unique, however the field does not seem to
| recognise the difference between certain ascii
| characters, for example it things that
|
| multimedia
I have a mysql table (MySAM), a field in there is set
to unique, however the field does not seem to
recognise the difference between certain ascii
characters, for example it things that
multimedia and multimèdia are the same (I hope it is
shown correctly) but basically it dos not recognise
chara
