[Mono-list] Problem inserting spanish characters

Jorge Bastos mysql.jorge at decimal.pt
Fri Apr 21 11:49:07 EDT 2006


U still have the column to change the charset and collation.
try to see if it works
  ----- Original Message ----- 
  From: Roberto Zenteno 
  To: Jorge Bastos 
  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 
    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/4c49f3fe/attachment.html


More information about the Mono-list mailing list