Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Using COLLATE in WHERE clause

1 view
Skip to first unread message

MacMax

unread,
Nov 11, 2010, 8:00:27 AM11/11/10
to
Hi to everybody,
i would like to find every record where the text field is not UTF-8,
it's possible?

The official MySQL manual doen'st report anything like this.
Thanks in advance.

Max
--
http://www.maxori.it
L'Arte è la capacità di fare cose di nessun valore
e di riuscire a venderle
F. Zappa

pCarsten

unread,
Nov 14, 2010, 5:35:18 PM11/14/10
to
The collation is a column attribute, not a field attribute. Not sure
what you're trying to achieve?

/ Carsten

MacMax

unread,
Nov 15, 2010, 3:31:43 AM11/15/10
to
pCarsten <pcarsten_n...@gmail.com> wrote:

> The collation is a column attribute, not a field attribute. Not sure
> what you're trying to achieve?
>
> / Carsten
>
> Den 11-11-2010 14:00, MacMax skrev:

Thank for your answer, i've resolved with some php function.
The textfields were archievied in differents formats. With
mb_detect_encode, iconv() and a custom function i've found the solution.

Max
--
http://www.maxori.it
L'Arte � la capacit� di fare cose di nessun valore

0 new messages