Re: not valid character for Unicode

Em Sábado 10 Junho 2006 05:31, Adam Witney escreveu:
> yep it is there, when i display the data from the application (PHP) it
> shows the character on the web page. Also this causes errors when i dump
> from 7.4 and try to load into 8.1 (i've read that the UNICODE checking
> became more stringent in 8)
>
> so basically 8.1 won't accept this character... im just not entirely
> sure what to do about that?

Are you on a Unix/Linux machine? You can dump the file there and run "file
dump.sql" to see what type of file it reports. If it says something other
than a string containing "text" and "utf-8", then you can edit the dump
manually and set the client encoding to whatever it is reported and try
restoring it or you can run "iconv" on the file and see if the conversion to
utf-8 works.

--
Jorge Godoy <jgodoy(at)gmail(dot)com>