[Mono-list] Problem inserting spanish characters

[Roberto Zenteno]

Hi Jorge, following your suggestion I did this

ALTER DATABASE DBempleos CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE CatEmpresas CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE CatEmpresa CONVERT TO CHARACTER SET utf8 COLLATE
utf8_general_ci;

And the behaivor is the same, it puts a ? instead of de Ñ.

Thank you.


2006/4/21, Jorge Bastos <mysql.jorge at decimal.pt>:
>
>  Robert, You need to define the mysql charsets and collations also
> set the database, table and the field to charset utf8 and collation
> utf8_general_ci
>
>
>
>  ----- Original Message -----
> *From:* Roberto Zenteno <roberto.zenteno at gmail.com>
> *To:* Mono-list at lists.ximian.com
> *Sent:* Friday, April 21, 2006 3:56 PM
> *Subject:* [Mono-list] Problem inserting spanish characters
>
>
> Hi ,
> I have a form in asp.net using mono-1.1..13, and when I insert data that
> contains  Ñ or a vowel with an accent  á, é ,  my page puts a ? instead.
> In the head's page I have <meta  http-equiv="Content-Type"
> content="text/html; charset=UTF-8">
> And I compile the application using -codepage:65001
> I'm using mysql-4.1.13.
>
> Any ideas.
>
> Thank you.
>
> ------------------------------
>
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20060421/5a62f859/attachment-0001.html