PDA

View Full Version : MySQL and accented characters



Dr Lovegrove
2006-03-27, 07:03
Quick question about TBS chars and MySQL (or possibly 6.5)..

When Moose scans a MySQL database on 6.5, it's given TBS
characters as 2-byte values: "Veinte Años"
The CLI also gives 2-byte values: "Veinte%20A%C3%B1os"

But on 6.2.2 with SQLite, it gets single-byte characters from
the DB: "Veinte Aos" and CLI: "Veinte%20A%F1os"

Is this a known 6.5 issue, or is it just that my MySQL default
character set is wrong ?

Also, what actually is the '%C3%B1' value ? I guess I need to
convert that into '%F1' in .net somehow, but I can't for the life of
me work out how..

Any help or advice would be most welcome.. Thanks,

--
- Dr Lovegrove
http://www.rusticrhino.com/drlovegrove

Dr Lovegrove
2006-03-27, 08:37
On 27/03/06, Dr Lovegrove <drlovegrove (AT) gmail (DOT) com> wrote:
> Quick question about TBS chars and MySQL (or possibly 6.5)..

Ahh, sorry, sussed it.. Brain not turned on today, and the MS
classes were mis-behaving.. http://www.utf8-chartable.de/

--
- Dr Lovegrove
http://www.rusticrhino.com/drlovegrove

bearklaw
2006-04-08, 21:38
When using MySQL you should be sure to create the database with the correct encoding specified. I just updated the Wiki page with some instructions. Chances are your db is using the default encoding of your computer.

-Barry