[Mono-list] Problem inserting spanish characters

[Roberto Zenteno]

It is finally working, besides what Jorge suggest me I convert my files to
utf8
vi -c ":wq! ++enc=utf8 form.aspx"

Thank you


2006/4/21, Jorge Bastos <mysql.jorge at decimal.pt>:
>
>  U still have the column to change the charset and collation.
> try to see if it works
>
>  ----- Original Message -----
> *From:* Roberto Zenteno <roberto.zenteno at gmail.com>
>  *To:* Jorge Bastos <mysql.jorge at decimal.pt>
> *Cc:* Mono-list at lists.ximian.com
> *Sent:* Friday, April 21, 2006 4:30 PM
> *Subject:* Re: [Mono-list] Problem inserting spanish characters
>
>
> 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
> >
> >
> >
>
> _______________________________________________
> 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/b66d4340/attachment-0001.html