[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