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
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?
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
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?
what you're trying to achieve?
/ Carsten
MacMax
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