If different clients use differnt charsets you will get problems if one
client stores a character that another client's charset doesn't have.
E.g. if one client stores an Ä (A with two dots) and another client uses
plain ASCII charset, the Ä can't be sent to that client, and a
translitteration error occurs.

This is assuming the data columns are created with a charset that is a
superset of all occurring client charsets, e.g. UTF8.

If the data column's charset doesn't have a character a client tries to
store using a different charset, a translitteration error will occur on
that insert/update.

To be on the safe side, if you don't know what charsets and data clients
will enter, create columns with UTF8.

Kjell

Den 2011-05-30 22:30 skrev heineferreira såhär:

>
>
> What happens if different users use different chactersets?
> I think it will cause problems but I don't know what problems?
> How do you resolve it if happens to you by accident?
>
> H.F.
>
>

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64