Posted by J.O. Aho on 01/26/06 14:35

jack wrote:
> "J.O. Aho" <user@example.net> wrote in message
> news:43rsujF1o1mcgU1@individual.net...
>
>> If I remember it right, BLOB can be what ever while TEXT is supposed to be
>> characters that are included in the charactersetup used for the database.

> Can you pls explain what you mean by charactersetup used for the database?
> So with BLOB I won't get any wierd side effects when the user enters various
> characters into it?

Character setups can be ISO8859-1, KOI8-R, BIG5, this tells how different
characters above ASCII 127 are mapped. Characters that is part of one
character setup don't have to be part of another. MySQL supports this and yuo
can set columns to have a specific character setup with the "CHARACTER SET".

If you try to save characters like äö in a database which is set to use ASCII
characterset then the characters will be lost when the data is saved.


//Aho

[Back to original message]